Link to home
Start Free TrialLog in
Avatar of jknj72
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
ASKER CERTIFIED SOLUTION
Avatar of YZlat
YZlat
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jknj72
jknj72

ASKER

My problem is that I am trying to write duplicate rows but that doesn't take away from the fact that I couldn't get the Redirecting to work. I have since taken it off and will have to repost again when I try to use it. Thanks for the help though
Avatar of jknj72

ASKER

Thanks