Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS Error row redirection and event handling

Author  Topic 

Starting Member

19 Posts

Posted - 2015-04-17 : 11:09:19

Currently in my SSIS project I am redirecting my OLEDB Destination error outputs to a flat file. But there is a requirement that if the error redirection is happening due to some constraint violation such as primary key, then rows should be redirected and at the same time on error event should also be raised.

Can someone kindly tell me is this possible ion SSIS? As far as I know if errors are redirected then no events get raised. Also how will I be able to identify from the package whether the rows are getting rerdirected due to truncation issue or constraint violation?

- Advertisement -