• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

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?
0
sbornstein2
Asked:
sbornstein2
1 Solution
 
Alpesh PatelAssistant 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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now