Error handling in SSIS

Hi!

I guess this is an easy one, but I haven't found a (nice) way to handle "error"-rows.

In my application I load a lot of data, in earlier version I used the Transformation task, which did deliver log and error-files. How do I make the same in SSIS? In the best of worlds I would like to log when a package/task i starting, ending and how many rows are OK and how many rows are errors. For the errors I want a Description what is wrong (FK, PK, NULL value ....) and the complete row in a file so it will be easy to reolad it.

I've tried the logging-feature but when I redirects the error-rows to a text-file, it also eliminates the error text in my log file. So it seems that I have to choose to have the description or the row-records?!

Best, Jocke

Hi,

You can include the error description in the text file using this simple technique: http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

-Jamie

|||

Thanks for your reponse!

But, I've tried that, but it will only give "No status is available." in the errordescription :-(

// Jocke

|||

Unfortunately that's all you'll get for some errors. I wish it weren't the case but there you are!

-Jamie