SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Firstime migration of FileSystem 2008 SSISPackages
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rcorp
Starting Member

12 Posts

Posted - 09/07/2012 :  13:41:43  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 09/09/2012 :  12:51:27  Show Profile  Reply with Quote
create deployment manifest for project.

http://www.mssqltips.com/sqlservertutorial/213/deploying-ssis-packages/

make sure package protection is set to save sensitive with password.

the server etc properties can be set through package configurations

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

rcorp
Starting Member

12 Posts

Posted - 09/13/2012 :  19:42:34  Show Profile  Reply with Quote
Thanks visakh. I will try your suggestions and get back if I have any other questions.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/13/2012 :  22:08:56  Show Profile  Reply with Quote
welcome
let us know how you got on...

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000