Velym (7/29/2014)
Thanks for those!Can someone give me an example scenario with an occurring deadlock? I have not encountered this so far - so I'm not sure on how to tackle this.
Typically this can encounter when you are using stored procedures and/or execute SQL tasks with transactions. So the typical deadlock scenarios you can find in literature, but just executed from SSIS.
I remember having SSIS lock up once because I used multiple data flows with transactions[/url] that read and write to the same table simultaneously.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP