August 9, 2012 at 12:13 am
Hi,
I am using SSIS 2008.
Can anybody please explain me how do we handle errors while using Bulk Insert? I need to capture the exact row errors and on which column?
If we cannot do that using Bulk Insert Task is there any other alternative for Fast Load and capture exact row errors?
August 9, 2012 at 10:37 am
Try some of these options.
Option A:
- Use bcp to import data (after dropping all keys/constraints etc)
- Recreate all the keys/constrains after the data load
- Run the validation routine in SSIS to flag questionable data
Option B:
- If you're using flat-file to import data via SSIS. Look into "Error Output" in Flat-File-Source-Editor
- Set the behavior (i.e. redirect/fail/ignore) you want to have happened on error/truncation of each column
I'm curious to learn how others approach this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply