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
 Other Forums
 Other Topics
 dtsrun

Author  Topic 

etnad7
Starting Member

16 Posts

Posted - 2010-10-03 : 22:18:53
hi guys, how can i execute a DTS package on a batch? is it something like this? dstrun /N "name of the dts package" /E. thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-03 : 22:40:07
Yes, run dtsrun /? from a cmd window to see its options. Alternatively, you can google for dtsrun and get to this: http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-03 : 23:19:37
While Tara already pointed you to the documentation, I'll just say that in your sample script you left out the server name

dstrun /SserverName /N"name of the dts package" /E
Go to Top of Page

etnad7
Starting Member

16 Posts

Posted - 2010-10-04 : 01:24:12
than you guys! :)
Go to Top of Page

etnad7
Starting Member

16 Posts

Posted - 2010-10-05 : 02:51:09
is there any way i can generate an output file? thanks!
Go to Top of Page
   

- Advertisement -