SSIS flatfile source false behavior on redirect row on error - by Christian Terhart

Status : 


Sign in
to vote
ID 778823 Comments
Status Active Workarounds
Type Bug Repros 4
Opened 2/8/2013 4:24:34 AM
Access Restriction Public


Hi there,

I have defined a flatfile connection in SSIS. (e.g. 4 columns, row delimiter <tab>, quote-ident ", row delimiter <lf>)
In the flatfile source I created an error redirect output for error and truncation.

If the flatfile has a row that does not fit the definied columns the package is failing.
If you run this in debug mode, the flatfile-source will start but not go any further when coming to error row.
The redirect of the row is not working but the tasks does not go further.
If you change the error behavior to "ignore failure" the "broken" row is ignored and the flow is working correctly.

Sign in to post a comment.
Posted by Calico Eric on 8/16/2013 at 11:53 AM
I have a similar problem where my input is about 3.2 million rows out of which 200 rows are not making it through the flat file source. However, those erroneous rows are not going to the flat file destination set up for error output either.

I have set up explicit OnError handlers for all possibly relevant steps and they are not getting hit (each sends me an email if invoked).

In my case I have set the truncation action to fail and the error action to redirect row. That configuration is repeated for *all* input columns (as is the default).

I have confirmed that my file destination for the error output does not have any permission issues for writing to it.

This is looking more and more like an SSIS bug. We need to be able to inform users importing data which rows are in error and the current SSIS behavior is preventing that and thus this is significantly affecting our data import functionality.