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)
 DTS deployment guide????

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-09-25 : 07:53:34
Hello..

can any body guide me how to deploy my .dts files to my client side by dtsrun.exe

i have sql server 2000 EE and my client has same version sql server 2000.

T.I.A

Shashank

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-25 : 08:29:31
I think DTSrun is just ment to run the DTS Packages, I am not aware of any option through which you can deploy the *.DTS file to the remote client using "DTSrun" utility. ("dtutil" can be used in SQL 2005 to move packages from one place to another)

Copying the *.DTS file to the remote client should work for you. I am not sure if you want this or not.

Thanks
Rishi Maini
Go to Top of Page
   

- Advertisement -