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

SSIS Error Output To SQL Table Expand / Collapse
Posted Thursday, April 24, 2008 6:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 11, 2012 12:26 PM
Points: 3, Visits: 106

Please anyone can help me out..

I am trying to run a simple packag wherein I am trying to take data from Excel sheet and storing it into SQL Table.

If i am entering wrong data in age field and trying to execute the package, I want that error record to be inserted in error table.

Please try to modify the package and send back to me...

Its urgent....


  Post Attachments (28 views, 9.11 KB)
Post #489830
Posted Friday, April 25, 2008 11:51 AM


Group: General Forum Members
Last Login: Yesterday @ 12:02 PM
Points: 476, Visits: 1,130

What I do in situations like this is preprocess the data. Use the SSIS job to copy the data to a temp table, scan it for errors and mark the errors.

Your temp table should have columns for the errors so you can easily select on which ones are bad. I personally use 2 columns, ErrCount for the number of errors found on the row and ErrDesc which is a large varchar describing the errors in words. Works well for working with end users.

Depending on the errors you can stop the job and print the errors or continue with the import.

Good Luck
Post #490870
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse