SSIS Error Output To SQL Table

  • 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

  • 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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply