First Time Migration of a File System 2008 SSIS package from Dev to Prod

Question

First Time Migration of a File System 2008 SSIS package from Dev to Prod

r_corp

SSC-Addicted

Points: 457
More actions
September 7, 2012 at 11:39 am

#280972

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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mackers SSCrazy Points: 2935 More actions · Answer 1

To do this we set-up a configuration file (Go SSIS-->Package configuration-->Add) where the location of the configuration file is stored as an environment variable

This way we only have to copy the packages from dev to prod and it automatically picks up the config file and adjusts the variables (my database connections use variables)

A good artice from Vyas Kondreddi on the subject:

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

Mack

Chris Hurlbut SSCarpal Tunnel Points: 4162 More actions · Answer 2

Using SSIS Variables for:

Data Locations - Process and Archive folders

Server Connections (Dev/Prod) - This is kinda cool, create connection strings using the variables, then when migrating just change the variable(s) (usually the Servername property in the expression for the connection)

After all the SSIS packages are tested and pass QA. We fill out deployment documents and have code reviews. The developer who wrote the package usually never deploys the code.

Last but not least is Stabilization...After the code has been deployed, the developer verifies all the processes are running correctly for the first few runs.

We also schedule jobs using proxy accounts.

If you are working on high visibility projects it is a good idea to come up with standard processes and to follow those processes. Most mistakes occur when code changes are done on the fly and under stressful circumstances.

Good Luck...

brosspaxedi SSCommitted Points: 1591 More actions · Answer 3

Are configuration files two way in the BIDS 2008r2 IDE? I mean, if I save my configuration as "prodconfig" then remove the prodconfig from my list of configurations, then change the values to test values and save the configuration as "testconfig", then remove testconfig from my list of configurations, then add my prodconfig back, will it restore my variables to the values I had stored in the prodconfig file?

Thanks.

*******************
What I lack in youth, I make up for in immaturity!