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)
 need help calling batch file via dts

Author  Topic 

cubswin
Starting Member

1 Post

Posted - 2005-10-27 : 11:38:49
i need help calling a batch file that will run on a remote server, while also passing the batch file a variable based on the results of a sql query using a dts package. i would like to process this either using the execute process task or activex.

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2005-10-27 : 11:59:02
You can execute the batch file using XP_CMDSHELL in your DTS package.

Please check this link
http://www.sqlteam.com/item.asp?ItemID=10627

Hope it helps.

Regards
Sachin Samuel
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-28 : 06:57:03
Hi,

refer [url]www.sqldts.com[/url] also.


HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com
Go to Top of Page
   

- Advertisement -