| Author |
Topic |
|
chintan009
Starting Member
8 Posts |
 Posted - 2012-04-05 : 15:29:20
|
| Hi I got on New task to complate , Right now i have some decrition about that...Here it is " Migrate/Consolidate DTS/SSIS packages from old Data warehouse servers to the New ETL server " If anybody have knowlege as Step by step plz,,,Replies Thanks in addvance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-05 : 15:53:02
|
| why dont create a deployment utility involving all SSIS packages by organising them into project? then you can simply run utility in new server to migrate packages. Make sure also move configuration files if you've defined any for the package------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 15:59:01
|
| -------------------------------------------------------------------------------- why dont create a deployment utility involving all SSIS packages by organising them into project? then you can simply run utility in new server to migrate packages. Make sure also move configuration files if you've defined any for the package------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ Visakh16 let me tell you one thing i m new here ,infact very new here , i need some step by step instructions . |
|
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 15:59:45
|
| you can send me mail also if you want |
|
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 16:00:17
|
| please Visakh , help me out |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 16:20:28
|
| Let me ckeacked out then i will come back to you soonThanks for reply |
|
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 16:23:36
|
| Visakh I have to one more tast in short time & the task involves researching all the sources of data that are compiled to create the IT Executive Report .IT executive report will be create by others Do you have idea that what i can use? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-05 : 16:33:31
|
| hmm...your question doesnt make much sense to mewhat's IT Executive Report ? is it report created somewhere?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
chintan009
Starting Member
8 Posts |
Posted - 2012-04-05 : 16:58:13
|
| Its is creted by some other team its IT executive |
|
|
|
|
Migrate DTS/SSIS Packages