Solved

SSIS - Lookup Transform - Redirect Row - Flat File?

Posted on 2011-09-02
2
493 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now