Starting an SSIS Package

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  September 11, 2016 at 5:10 am

  #100936

  Comments posted to this topic are about the item Starting an SSIS Package

• September 12, 2016 at 2:05 am

  This was removed by the editor as SPAM

• George Vobr

  SSChampion

  Points: 10009

  More actions

  September 12, 2016 at 6:31 am

  #1900297

  Thanks for an interesting question Steve.

  The reference MSDN catalog.start_execution (SSISDB Database) gives only an example

  with the parameter N'LOGGING_LEVEL'. The use of other parameters is well explained here:

  http://sqlblog.com/blogs/andy_leonard/archive/2015/11/04/the-synchronized-ssis-execution-parameter.aspx

  or here:

  http://www.ssistalk.com/2012/07/24/quick-tip-run-ssis-2012-packages-synchronously-and-other-execution-options/

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  September 13, 2016 at 12:30 am

  #1900448

  Nice one

  More on concurrency 🙂

  Ta

  Iulian

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  September 13, 2016 at 1:28 am

  #1900456

  Thanks for the question. I believe there's a parameter for the stored procedure where you can set it to run synchronously.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  September 13, 2016 at 6:40 am

  #1900518

  Thanks for the question.

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  November 4, 2016 at 8:06 am

  #1910603

  There's also a synchronous setting

  Been caught out by this before where I was left wondering why it kept responding immediately

  - Damian