Migrate DTS packages from dev to live server

[paulcarolyn1637]

I am using DTS packages to populate a new Sql Sever 7/2000 Datamart. The data feeds initially are all TXT files.
The development work has been done on Server A and will need to be implemented onto Server B.
All the connections make explicit references to Server A.
How can I develop packages to allow easy movement between development environments?
Can Global/system variables be utilised and if so how?

Any advice is most welcome.

PJG

 

[Guest_imported]

You'll need to manage the connections (and probably the whole package) using the DTS object model. In this case it will be easy to load your parameters including thse server name from some static source as the registry or a text file.

 

[tlbroadbent]

You can use global variables. Check out Darren Green's article on "Migrating DTS Packages" at SWYNK.com.

http://www.swynk.com/friends/green/dtsmigrate.asp

Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin