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)
 run the dTS from the batch file

Author  Topic 

muhiar
Starting Member

37 Posts

Posted - 2006-04-26 : 09:35:34
hi all
i have a problem and it is sooooo urgent

can we call a dts package using a batch file in c:\ drive (call the dts directly or batch file call stored procedure to do so )? and what should be the syntax for the stored procedure(if any) and the batch

any other idea can help me
thnx in advance

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-04-26 : 10:04:57
dtsrun /S<ServerName> /E /N<PackageName>
Go to Top of Page
   

- Advertisement -