x

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

amy101
11 1 1 1

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

1 answer: sort voted first

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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x946

asked: Dec 12, 2011 at 08:36 AM

Seen: 644 times

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