Re: SSIS project migration
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Jun 2007 21:27:42 +0000 (UTC)
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
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,
Thanks
.
- Prev by Date: Re: SSIS isDate() function?
- Next by Date: RE: DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
- Previous by thread: Re: SSIS and Transactions
- Next by thread: DatePart in a DTS
- Index(es):
Relevant Pages
|
