DTS text file import does not import all rows from text source

Last Post 12 Oct 2007 09:34 AM by eolivera. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
eolivera
New Member
New Member

--
12 Oct 2007 05:23 AM
We have a DTS package that does the extraction portion of an ETL process. It has never given us trouble and no errors where recorded. For all files extracted, it is set to fail on the first error. This week a user found quite a few records missing from the last load. I checked his claims against the table loaded and they were not in. But the problem is that the rows are in the source text file. The package does not use bulk insert and the text file is delimited. What could possibly be preventing theses rows from loading?
Ed
eolivera
New Member
New Member

--
12 Oct 2007 09:34 AM
I finally figured it out. The row after the last one loaded was corrupt. After I deleted it, all the outstanding rows were loaded.
Ed
You are not authorized to post a reply.

Acceptable Use Policy