SSIS deadlock

[Darth Vodka]

am i right in thinking that if i have two parallel data flows into the same table then the first one to hit deadlocks the table and i have to do them in series?



aaaah found the "lock table" option on the OLE destination component

 

[SQL_Hell]

yes it might deadlock, not saying it defintely will but if you do run two steps at the same time into the same table you are leaving yourself open to the possiblity of deadlocks.

I would run them in series, SSIS is much quicker than DTS anyway