Moving SSIS project

I am trying to move an entire SSIS project from one machine to another (with a different directory structure) in a Development environment. In addition to the packages themselves I have Data Sources and Data Source Views defined. I also have connection managers for Excel and SQL Server that use those data sources, and connection managers for flat files for my error logs. Finally, I have saved my package configurations in an XML file.

I've followed the steps in the following post to move my packages:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817897&SiteID=1

What else exactly do I need to do, though, to move my complete project. My objective is to start up BIDS on the new server, File -> Open -> Project/Solution and point it to the new <project>.sln file and have it work. I know I need to edit my config XML file, but other than that, how do I properly move/recreate the data sources, data source views, and solution files in the new location. I've tried several things, but with no luck.

Thanks!

N Bauer wrote:

I am trying to move an entire SSIS project from one machine to another (with a different directory structure) in a Development environment. In addition to the packages themselves I have Data Sources and Data Source Views defined. I also have connection managers for Excel and SQL Server that use those data sources, and connection managers for flat files for my error logs. Finally, I have saved my package configurations in an XML file.

I've followed the steps in the following post to move my packages:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817897&SiteID=1

What else exactly do I need to do, though, to move my complete project. My objective is to start up BIDS on the new server, File -> Open -> Project/Solution and point it to the new <project>.sln file and have it work. I know I need to edit my config XML file, but other than that, how do I properly move/recreate the data sources, data source views, and solution files in the new location. I've tried several things, but with no luck.

Thanks!

You just have to copy the sln file and the sub-folder containing the .ds, .dsv, .dtsx and other files to the new machine. And yes, you should use package configuration to set up connections, paths and other property values that can change from environment to environment.

Did you get any error when opening the project in BIDS? what exactly is you problem?

|||

Sorry for the delay, but I was out of town and then got sick. Anyway, I have gotten the hang of moving packages/projects and using configuration files. For the benefit of others here are the two things that caused me the most grief:

1. Connection managers and configuration files - just as soon as you save a configuration file it takes precedence over any settings within the package itself you might make within BIDS. For database connections, the password IS NOT SAVED in the configuration file. Therefore, immediately within BIDS it appears that your connection managers are hosed as you will get error messages to that effect. Thus, I recommend the following steps for using XML configuration files:

Save the configuration file

Open the package you want to create a configuration file for

Choose SSIS - > Package Configurations

Check "Enable package configurations", be sure to choose the connection managers from the pick list, and save the xml file to the location/name of your choice.

Finish

Immediately, close and save the package.

sql