Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Running SSIS package in synchronous mode

Author  Topic 

mrhr2461
Starting Member

2 Posts

Posted - 2010-01-06 : 09:57:19
I have an SSIS package that I run from a stored procedure. However, I have noticed that it often fails because of deadlock. How can I run it in a synchronous mode to make sure it completes before the rest of the code in the stored procedure executes. Any help would be appreciated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 10:14:01
http://sqlblog.de/blog/2009/09/ssis-execute-package-via-stored-procedure/
Go to Top of Page
   

- Advertisement -