January 9, 2017 at 9:47 am
Hey guys, I have an ssis package where I have a staging table with the rows that need to be sent to separate files. I pull all the rows that go into a specific file then update those records status column in the staging table so they aren't selected again. I have 2 copys of this logic where there can be 2 files cut at the same time all in a for loop. Every now and then I'll get a transaction deadlock issue when both try to update the staging tables status column at the same time. IS there anyway I can stop the deadlock and make the process just wait for the other to finish and not get the deadlock issue?
January 9, 2017 at 11:26 am
Should these processes actually be running at the same time? If they are both going to update a column at the same time, then you're going to be getting a deadlock.
What determines when either one starts? Could you not just ensure that one runs after the other?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply