Using stored procedure to call multiple packages at the same time from SSIS Catalog (SSISDB.catalog.start_execution) resulted in deadlock
- by Kevin Shyr
Refer to my previous post (http://geekswithblogs.net/LifeLongTechie/archive/2012/11/14/time-to-stop-using-ldquoexecute-package-taskrdquondash-a-way-to.aspx) about dynamic package calling and multiple packages execution in these posts:
I only saw this twice, other times the stored procedure was able to call the packages successfully. After the service pack, I haven't seen it...yet.
http://support.microsoft.com/kb/2699720