SQL Server 2008 SISS error row handling

5 pts.
Tags:
SQL Server 2008
SQL Server 2008 Integration Services
SQL Server Integration Services
SSIS
Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table
ASKED: January 4, 2009  9:27 PM
UPDATED: January 5, 2009  2:37 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Create a second destination. Click on the source, and grab the red arrow and connect it to the second destination. When the window opens change the columns that you want to trigger a redirection to redirect row.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following