Solved

SSIS - Lookup Transform - Redirect Row - Flat File?

Posted on 2011-09-02
2
497 Views
Last Modified: 2012-08-13
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
Comment
Question by:sbornstein2
2 Comments
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 36473396
Please transfer error rows to SQL table or flat file etc using redirecting the rows as in image.
Untitled.png
0
 

Author Closing Comment

by:sbornstein2
ID: 36473631
thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Getting max record but maybe not use Group BY 2 27
sql help 8 55
SSRS 2013 - Overlapping reports 2 22
SSAS Hierarchy with columns with folder names 10 14
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question