DTS : Is scripting possible???

[Rosko]

First of all? I want to keep everything on SQL server.

I have a server(4 processors, 300 Gb, 4Gb Ram) with 3 instances of SQL server running. and this for the purpose of developpement, acceptation, production)

On each instance the same databases.
I created a few DTS packages on the developpement instance but there will be a lot of packages.

So for migration purposes (developpement to acceptation to production) I'm searching for a way to migrate the packages from one instance to another.

I've tried using the option "(local)" as server in the connection properties tab but that always refers to the default instance which means if I use the save as option in a DTS package to save it on an other instance it still uses the databases on the default instance.

In short, I want to store it on another instance and change the connection properties automatically so it uses the instance name where the package has been saved.

Does anyone know a possibility to script DTS packages or dynamically set connection properties within a DTS package.
But try to keep it on SQL server. I think it is possible if you save it as a visual basic file but I want to avoid leaving the SQL server platform.


Thanks for the help

Rosko

 

[Rosko]

Another question, is it possible to determine the instancename(server\instance) where the package is saved without having to write a query?


Rosko