Fire off a SSIS package from a Stored Procedure

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  November 28, 2007 at 2:21 pm

  #119638

  Hello All

  After reading more and more of the code that was written by a front-end developer, I need to go thru all the sprocs and replace the entries that use BCP with code that calls a SSIS package.

  I am not sure though how I can fire off the package from within the sproc. Can I call the PackageID? Just like I would launch a SQL job?

  Any advice on this would be greatly appreciated. Thanks in advance for your help

  Andrew

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  November 29, 2007 at 2:12 am

  #755280

  I think the best way is to use SQL job. SQL 2005 has special step type: SQL Server Integration Services Package.

• Giri Duddu

  SSCommitted

  Points: 1638

  More actions

  November 29, 2007 at 2:19 am

  #755286

  u can use

  sp_executesql

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  November 29, 2007 at 10:24 am

  #755548

  Can you elaborate on that just a little bit? Maybe a simple code sample?

  Thanks

  Andrew

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  November 29, 2007 at 12:10 pm

  #755620

  I think you must read this thread:

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=61765&SiteID=1