Extra Column In Comma Delimited File

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.
more ▼

asked Dec 12, 2011 at 08:36 AM in Default

amy101 gravatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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.
more ▼

answered Dec 12, 2011 at 02:48 PM

Daniel Ross gravatar image

Daniel Ross
2.9k 11 13 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 12, 2011 at 08:36 AM

Seen: 638 times

Last Updated: Dec 12, 2011 at 08:36 AM