Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Amit-1234
Starting Member
19 Posts |
Posted - 2015-04-17 : 11:09:19
|
Hi,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? |
|
|
|
|