Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to deploy a DTS Package

Author  Topic 

THNQdigital
Starting Member

15 Posts

Posted - 2005-05-02 : 16:20:28
Hi,

I have DTS package ( SQL 2k) on the test server.
I need to deploy the same on to PRO server.

I am planning to save the package as Strutured storage file on the disk and then copy the file (.dts) file to PRO and open the packge in DTS ( PRO SQL Server). is this correct method.. ? Please let me know.

Thanks
THNQDigital

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-05-03 : 00:51:59
Thats what I do. Open the .dts file in the server then go to save option and save to server. This works fine for me.

Karunakaran
___________
It's better to be loved and lost, than ever to be loved...
Go to Top of Page
   

- Advertisement -