Hi, I have flat file source(with 20 columns) in my SSIS2012 package. For error handling, I chose Redirect error row in Source file and re-directed to another flat file. Surprisingly I am able to see only 3 columns i.,e All columns concatenated in single column, ErrorCode and ErrorColumn instead of 20+2 columns. Any idea how to re-direct all the columns separately. Please suggest. Thanks.Porus

Hi Porus, please share a screenshot. I expected you to see a grid with 20 rows in which you choose each column setting individually. This makes me believe you misconfigured the source.Arthur My Blog

I suspect that your flat file connection is not parsing your flat file into separate columns. Instead it reads a whole row of data as a single line and hence you are seeing a single column instead of 20 columns. Fix your flat file connection.http://btsbee.wordpress.com/

when you get error output from a flat file source, it will bring whole input row into error output, because there might be a problem in reading one or more columns in that input records. so this will be much better for troubleshootinghttp://www.rad.pasfu.com

It will output three columns: Flat File Source Error Output Column, Error Code and Error Column. The Flat File Source Error Output Column includes all column data which're now a single string. In destination Flat File Connection Manager where you saw these three columns, to remove the Error Code and Error Column from Connection Manager Editor, and change 'Flat File Source Error Output Column' data type from text steam to Unicode string, and the width should be the total length of columns. The row and column delimiter can be {CR}, no header be outputted, then try to execute package, you will see all column data without extra error information. The output columns should be delimited by TAB.Please vote if it's helpful and mark it as an answer!

It will output three columns: Flat File Source Error Output Column, Error Code and Error Column. The Flat File Source Error Output Column includes all column data which're now a single string. In destination Flat File Connection Manager where you saw these three columns, to remove the Error Code and Error Column from Connection Manager Editor, and change 'Flat File Source Error Output Column' data type from text steam to Unicode string, and the width should be the total length of columns. The row and column delimiter can be {CR}, no header be outputted, then try to execute package, you will see all column data without extra error information. The output columns should be delimited by TAB.Please vote if it's helpful and mark it as an answer!