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

user_1254579 0
Viewed 14969

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?

ssis sql-server-2008 sql-server
3 Answers

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.

user_167054190
Related