Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rcorp
Starting Member
12 Posts |
 Posted - 2012-09-07 : 13:41:43
|
| Hi All,I developed SSIS packages in our development server. I used my windows id in the development. The packages are created in the default location (My Windows id\documents\visual stiudio 2008\projects\...)Now I want to move the development packages to production server. This is the first time so there are no packages in Prod SSIS. I cannot use my windows id in production server. The IT team has created a different windows id in the prod environment. I am searching for migration procedures but couldnt understand a better way to do this.The locations in my connection managers may change since the dev and prod doesnt have the same drives/folders etc.I will modify the locations manually if I can move the packages first.This might be a newbie question but Please give me suggestions on how to handle this. Thanks for your time and appreciate your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
rcorp
Starting Member
12 Posts |
Posted - 2012-09-13 : 19:42:34
|
| Thanks visakh. I will try your suggestions and get back if I have any other questions. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 22:08:56
|
| welcomelet us know how you got on...------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Firstime migration of FileSystem 2008 SSISPackages