Post reply

how to call a dtsx with asp?

  • October 8, 2008 at 7:21 am

    #213846

    Hello,

    did somebody know how to call a dtsx with asp?

  • October 8, 2008 at 7:58 am

    #882279

    xp_cmdshell -google it

  • October 8, 2008 at 8:08 am

    #882296

    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.

  • October 8, 2008 at 8:11 am

    #882301

    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