Post reply

running dts

  • July 12, 2004 at 2:33 pm

    #60173

    this is a newbie question..

    Is there any to run a dts from query analyser?

  • July 13, 2004 at 5:13 am

    #514365

    /************* Run DTS Package **************/

    declare @package_name varchar(128)

    declare @cmd varchar(255)

    set @package_name = 'MyNiceDtsPackage'

    set @cmd = 'dtsrun /S SERVERNAME /E /N ' + @package_name

    execute master..xp_cmdshell @cmd --, no_output

    /******************************************/

    Lookup xp_cmdshell and dtsrun in BOL for more info...

    /rockmoose


    You must unlearn what You have learnt

  • July 13, 2004 at 11:20 am

    #514435

    I have also used DTSRUNUI to generate the command-line syntax to execute the DTS package, then put that syntax in a stored procedure.

    Then you can just execute the stored procedure in query analyzer or in a job or wherever.

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

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