Batch file and DTS variable

Last Post 23 Mar 2008 08:07 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

23 Mar 2008 04:46 AM
I have a batch file that calls a DTS package. In the DTS Package I am storing a value as an output variable that I want to send back to the Batch file to include in the body of an email that will be sent out. I am well aware of how to send variables TO the DTS package from the batch file using the RUNDTS command but I am not sure how to return variables back to the batch file.

Is it possible to send a variable from the DTS package back to the Batch file?

Thank You,
New Member
New Member

23 Mar 2008 08:07 AM
How about sending the email from DTS?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSAS, SSIS, SSRS - April 21-24:

Acceptable Use Policy