SSIS - Lookup Transform - Redirect Row - Flat File?

Hello all,

I am troubleshooting a package that someone else wrote that has a lookup that keeps failing.  I am trying to determine what records are failing.  All I want to do is dump the errors to a log or something so I can see what rows are failing.  Any idea how I can just quickly set that up so I can determine what table and row is failing?
sbornstein2Asked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Please transfer error rows to SQL table or flat file etc using redirecting the rows as in image.
Untitled.png
0
 
sbornstein2Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.