Calling SSIS package from SP

• prakash.tamilarasan

  SSCrazy

  Points: 2596

  More actions

  September 24, 2010 at 1:58 am

  #228733

  Hello there,

  I want to call a SSIS package which is stored in file system (\\srtb03.dr.infosir.com\tb\Package1.dts) through T-SQL script (stored procedure).

  Can anyone help me in this ?

  Regards,

  PT

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 24, 2010 at 2:31 am

  #1226764

  You can make use of DTEXEC command line utility. An example here

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga