Post reply

How invoke Dts from web browser

  • April 5, 2004 at 7:34 am

    #59821

    Hi

    Can any one guide me how to invoke a DTS package from Web Browser.

    Thanks

    Ramesh

     

  • April 5, 2004 at 8:55 am

    #501765

    not sure how to run a DTS package through code, but you could create a job for it and use sp_start_job.  All the proc does though is fires the job, the returncode is immediate.



    --------------------------
    Zach

    Odds_And_Ends Blog

  • April 6, 2004 at 3:07 pm

    #501931

    Make a sproc like

    CREATE PROCEDURE Run_DTS_Package AS

    exec master..xp_cmdshell 'dtsrun /S[ServerName] /N[DTSPackageName] /E'

    and then call that from whatever page the browser hits.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply