sql server dts: Hello Everybody,
I have SQL SERVER SSIS project developed in my development server.
Now I have to migrate project to QA server (basically all the SSIS packages)
so that I can run all the packages from batch file from QA server.

In the developement server, I have 3 datasource connections.
So my question is, I want to change connection in datasource while i migrate
to QA server.

SSIS files (.dtsx) , I can copy and paste in QA server but how can i change
..ds file with new connection so that all .dtsx package use that ?

Pls let me know,

Hello mvp,

The .ds file has nothing at all to do with the package. it is a project
level item and you do not migrate projects. You migrate packages which have
connection managers which may or may not be derived from Data Sources. It
is these (Connection Managers) that ned changing and the way to do that is
through Configurations. You migrate packages not the Development solution.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]