Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, March 4, 2013 10:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:02 PM
Points: 116, Visits: 207
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