I was just provided a bad production file. It contained three tab delimited columns instead of the expected two. I am using SSIS to load the file. Instead of just blowing up as would be expected. It just locked the table and said that I was trying to insert and delete from the same table. Does anyone have an explanation of why this occured? It took a couple of us about two hours to figure this out.
Thanks in advance for your response.
asked Dec 12 '11 at 08:36 AM in Default
The only reason that I can think of is that SSIS is locking the table to do the insert, and another process is trying to delete from the same table.
In the destination in the data flow, untick the table lock option. Importing data with the table lock selected do, from time to time, cause table locks. especially if the are updates or deletes in the same data flow.
answered Dec 12 '11 at 02:48 PM