jknj72
asked on
Redirecting Errors in SSIS
I have an OledDB source(Oracle) and a OleDB Destination(SQL Server) and I tried to add a Redirect on the Destination to another SQL table and I mapped the columns to the Error table which is the same as the Dest but has Error columns as well. The initial problem is a Foreign key Constraint so I wanted to know the bad rows and still Insert the good rows but it seems that all the rows are going into the Error table, which cannot be correct. I have attached a pic so you can see what Im talking about. Any help would be appreciated...Thanks
SSIS-Redirect-Row.png
SSIS-Redirect-Row.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER