running dts

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  July 12, 2004 at 2:33 pm

  #60173

  this is a newbie question..

  Is there any to run a dts from query analyser?

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  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

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  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.