Filter out SSIS errors

Question

The way SSIS generates errors are bit weird. Error detail contains lots of unnecessary data such as "pipeline stopped executing...", "the error is fatal..","The user requested a shutdown..." and on... This is not very user friendly for a end user. So I was wondering on is there any way where we can log/send specific errors only? In my case where I upload data from csv file to sql table for data conversion error SSIS sends me 20 lines of error log and I need to remove all unnecessary stuff. Any suggestion?

Answer 1

Since standard logging in SSIS does produce an overwhelming amount of junky, you could rely on using reports in SSRS that filter down some of this data. If you know you don't care about messages that contain specific phrases, then you could suppress them in your query with a NOT LIKE statement. Alternatively, you could setup a process to purge the records from the sysdtslog table if you absolutely know you never want them in your database. Neither are great solutions, but they are easy to implement without having to write a custom logging solution.

REVISION

You can log custom errors with event handlers. There's even an article on how to implement custom logging with custom tasks that literally takes the original article and goes a step further. Both of them are useful for understanding how you could control how error messages are logged and the content of the messages.