October 8, 2008 at 7:21 am
Hello,
did somebody know how to call a dtsx with asp?
October 8, 2008 at 7:58 am
xp_cmdshell -google it
October 8, 2008 at 8:08 am
From ASP you have two choices. The first is call DTSRUN with the dtsx file as a parameter, but if it takes any amount of time, you'll have a timeout on the ASP side.
The other way is to schedule the dtsx as a job (no times) and call sp_startjob from ASP. It will come back and then you can query the server with a refresh to see when it completes and get status.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 8, 2008 at 8:11 am
You can also create stored proc and exec xp_cmdshell inside it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply