How to export a DTS package to remote servers?

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I have written couples of DTS packages on my laptop. I need to transfer these DTS packages to many servers located around the country and schedule them. I have remote desktop access to these servers.

Is there any easier way that allows me to transfer these packages to those servers and schedule them without needing much work to do?

In the DTS package, there's a possility to execute another DTS package. Therefore, I need to reconfigure the DTS packages each time I schedule them. Is there any way that requires no such configuration? I need the solution urgently.

Thanks a lot!

-- Anonymous, May 22, 2004

Answers

Teoh,

To save the DTS package to another server, open up the package, click on the menu item Package, select Save As... and specify another server to save it to.

As far as reconfiguring the packages for each server, I have not found a way around this.

Good Luck,

Eric

-- Anonymous, May 25, 2004


Moderation questions? read the FAQ