What happens to ignored rows when Ignore failure is selected in SSIS?

Question

There are 3 components in the data flow: an OLE DB Source, Data Conversion transformation and a Flat File Destination. If I selected the Ignore failure option in the Data conversion transformation and some rows get ignored in that data conversion level then would those ignored rows move towards target? Or where can I get those ignored rows? Are those going to available in the log file?

What will happen to erroneous rows when I select Fail component as option?

Answer 1

The standard behavior when you select Ignore failure seems to be to ignore the offending values, not the rows that contain them. I just did a quick test (SQL Server 2008 R2) and values are imported with NULL instead of the offending values.

You can find a very helpful page with more information on error handling in SSIS Data Flow tasks here. An overview from that page of the relevant error handling options and what they mean:

Fail Component:
The Data Flow task fails when an error or a truncation occurs. Failure is the default option for an error and a truncation.

Ignore Failure:
The error or the truncation is ignored and the data row is directed to the output of the transformation or source.

Redirect Row:
The error or the truncation data row is directed to the error output of the source, transformation, or destination.

Answer 2

As per SQL 2014, if you set Truncate Row Disposition to "RD_IgnoreFailure" the column data will be truncated to the specified length and inserted into destination. For example, if the column size is 50 and the data length is 70, the first 50 characters will be inserted to the destination.