Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Half Flat File Imported through SSIS, No Error Expand / Collapse
Posted Monday, March 4, 2013 10:06 AM


Group: General Forum Members
Last Login: Wednesday, October 5, 2016 2:38 PM
Points: 151, Visits: 328
This has happened to me many times. I have a job that takes a flat file and imports it into sQL 2008 DB. From time to time, only half of a file will be imported, but no error is reported. If I reprocess the same exact file, it'll work OK, with all records imported completly. The file size doesn't seem to matter. It can happen to a file that has 5 rows, or a file that has half a million rows. I had the same issue when I was running DTS over SQL 2000 years ago.

Any idea?
Post #1426344
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse