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
Author
Message
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
Hi,

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....

Thanks
Pradeep


  Post Attachments 
SSIS_ErrorHandling.zip (28 views, 9.11 KB)
Post #489830
Posted Friday, April 25, 2008 11:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 413, Visits: 1,073
Pradeep,

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
John
Post #490870
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse