Migration in SSIS

Does anyone know about procedure of doing the migration of project in SSIS. We just need to copy the project folder or something else, so that every connection also gets configured on the new server. What is to be done to move the project onto other server?

Which aspect is not covered adequately by Books Online? There is an entire section on "Deploying Integration Services Packages."

-Doug

|||

Amarpreet wrote:

Does anyone know about procedure of doing the migration of project in SSIS. We just need to copy the project folder or something else, so that every connection also gets configured on the new server. What is to be done to move the project onto other server?

Refer to the section(s) in BOL for:

- Creating deployment utility.
- Using DTSInstall.EXE to install packages on another/same server.
- Using DTUtil.EXE for moving packages between machines.
- Using package configurations (specially using environment variable to hold the configuration file path and then using property expressions to dynamically assign connection properties using variables).

Basically, it takes some work.

HTH,
Nitesh|||Thanks Nitesh,

I am very much new to SSIS. If you could explian the last point of yours.
I have created the deployment utility and have copied my deployment folder to the other machine. Then I am using install package utility provided with SSIS. But the error is with the connections (OLE DB and Flat File), which had been created on my machine. How do I dynamically change the server name, username and password. All the required databases and flat files are present on the new server.
If you could provide the steps...
Thanks,|||Amarpreet,
Configurations are the method for doing this in SSIS. Here are some links that may help:

Location independant packages - http://www.windowsitpro.com/Article/ArticleID/47688/47688.html
Easy package configuration - http://www.sqlis.com/?26
Indirect configurations - http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx
Dynamicly changing packages - http://blogs.conchango.com/jamiethomson/archive/2005/03/01/1093.aspx
Another method is to change such values via the command-line:
Command-line params: http://blogs.conchango.com/jamiethomson/archive/2004/12/13/451.aspx
Configurations or command-line - http://blogs.conchango.com/jamiethomson/archive/2005/05/17/1424.aspx

Regards
Jamie