Batch for Transfering multiple DTS packages from one server toanother on SQL server 2000. -
12-29-2008
, 11:11 AM
We create DTS packages on development server and try to move the
packages to test servers.
We first extract the packages and save them as some kinds of binary
files.
When we are importing these packages to another servers we have to
rename them according to the server name.
Now we can only import each package one by one from the saved file. We
then have to enter username and password for each package.
I am looking for ways to be able to ease our work and let us to import
these packages by using either a batch file that is flexible enough to
let us alter the packages name and owner and stuff.
Please help me with this issue or direct me to some related posts or
articles.
Re: Batch for Transfering multiple DTS packages from one server toano -
01-15-2009
, 09:53 AM
thank you, the solution that we are using right now is to install VB6
and save all packages into BAS extension.
However, this is only able to transfer the package but not the design
comments, and the layout of the DTS pacakge will be changed to default
after the VB code is ran.