Post reply

how to run a dts packages

  • January 28, 2009 at 9:55 pm

    #73438

    hi all,

    I have created a dts package(first time), which contains two global variable one is input and other is output, I had run the activex script it is executed successfully.

    can anybody help me to run the dts package from query analyser in

    sql server 2000

    thanks in advance

    regards

    durgesh J

  • January 29, 2009 at 7:33 am

    #934670

    I dont think there is a direct T-SQL command to do that. But if you have to use T-SQL only, here is one way:

    1. Schedule the package in an SQL Server agent job.

    2. Don't add any schedule to the job.

    3. In the query analyser, use msdb..sp_start_job to start the job which will in-turn execute the DTS package.

    Girish

  • January 29, 2009 at 8:19 am

    #934719

    Had you taken the time to search the site you would have found this:

    [/url]

    Which is basically what Girish Bhat said.

    Please do not double post.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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