I need to call a DTS job from my ASP page, but can't figure out how to go about doing it. I've tries Books online, but can't find anything.<BR><BR>Thanks
Create a Stored Proc to call the DTS, then call the Stored Proc.<BR>
I am being very thick here, but I can't work out the stored proc to call the DTS job.<BR><BR>I thought it would be sp_exec_job, but that does find my DTS package.
that should be sp_start_job not exec_job. Still doesn't work though.
OK, post the ASP you are using to call the SP, <BR><BR>as well as the SP you have created.<BR><BR>