SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
r_corp
r_corp
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 33
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.
Mackers
Mackers
Right there with Babe
Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)Right there with Babe (717 reputation)

Group: General Forum Members
Points: 717 Visits: 499
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
Chris Hurlbut
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2082 Visits: 540
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
brosspaxedi
Old Hand
Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)Old Hand (317 reputation)

Group: General Forum Members
Points: 317 Visits: 261
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search