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.
| Author |
Topic |
|
mrhr2461
Starting Member
2 Posts |
 Posted - 2010-01-27 : 14:29:05
|
| I have an SSIS package on SQL 2005 that is called from within a stored procedure by executing sp_start_job to run the job that launches the SSIS package. It then checks on status of the job until it is complete. The package seems to fail occasionally because of deadlocking errors and I can't figure out what is causing the resources to be locked. There's usually no other user transactions taking place in the database so I think the conflict must be coming from my own process. Any idea what could possibly be causing the deadlock error and what is the workaround? I appreciate any help that you can provide.Thanks,Lynn |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
|
|
|
SSIS package failing due to dealocking