Discussion Locked

Exec DTS package in Stored Proc?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to execute a DTS package (saved as a local package) within a SQL Server 7.0 stored procedure?

4 replies

by mark.thomson

Try this

Schedule your DTS package to run - this will create a scheduled JOB, edit the scheduled JOB, in the STEPS tab, click the EDIT button, Cut and Paste the contents of the COMMAND memo field into a stored procedure and try to run it

by eugenestetz

O.K. I see that the job runs the dtsrun utility with machine code as the parameters. Would I then run the dtsrun utility with these parameters using xp_cmdshell in my stored proc?

This discussion is closed to new replies.