Untitled.png

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I am troubleshooting a package that someone else wrote that has a lookup that keeps failing. &nbsp;I am trying to determine what records are failing. &nbsp;All I want to do is dump the errors to a log or something so I can see what rows are failing. &nbsp;Any idea how I can just quickly set that up so I can determine what table and row is failing?
</div>
</div>


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?

SSIS - Lookup Transform - Redirect Row - Flat File?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.