Is there a way I can get actual field values for Error Rows while redirecting the error rows to a flat file. I have a data flow task with Oledb Source and flat file destination. I configured the Flat File Source Error Output and am only getting the ErrorCode and ErrorColumn in the error output for "Text was truncated error" -1071607675, 22180 But i'm not sure which column in which row resulted in this truncation error. Is there a way I can pinpoint the error Source? thanks.

Hi There, There is an API called componentMetadata that has some handy functions built in - one of which is the GetErrorDescription function - that returns a more detailed error description for the passed in ErrorCode - so you can use it quite simply to get the more detailed Error Description: ComponentMetaData.GetErrorDescription(Row.ErrorCode). There is more info on how to use this within a script component on MSDN & Technet - you could start here: http://technet.microsoft.com/en-us/library/ms345163.aspx

I am already using the GetErrorDescription and I know what the error is and also know which field it is: "Text was truncated or one or more characters had no match in the target code page" I would like to know which value of the field ticked off the data conversion process. The Length of the column specified in both the source and destination is 40 and I checked the Source data, there is no value in the sourceexceeding this limit. Thanks

The value that failed will be in the redirected row. Is that not why you used the redirect option to start with? You have the row and the column, therefore you can review the value... what am I missing?

Hi There,is there a similar way to get the column name (or any other human understandable description) from the ErrorColumn field?I've learned, that the number in ErrorColumn is the "lineageID". Now I wan't to extend this little script from http://technet.microsoft.com/en-us/library/ms345163.aspxwith some code that return an "ErrorColumnName" field. In my package there are a lot of columns, getting an new ID every transformation step, so the pure linageID will tell me less more than nothing.Thanks

Hello!I have the same problem/error.The minimum size of any columnsis 50 and none of the columns in my source have text above 50.I have two similar rows, one row gets inserted and the next don't. All columns in these two rows have the exact same length.What is wrong?Can anyone help?Best regards,Tina

You can use one of the components listed at the SSIS Community Tasks and Components site, specifically:Error Output Description - A component that takes error outputs from multiple data flow components, decoding the error code and column information into error descriptions and column names.eLog - A custom component for recording error flow information.

Hello!I found out that the CR/LF is not always recognized. The whole next row ends up in the last column. Then the last column gets above 50 wide. I hope that this is a file quality issue and are now waiting to receive new file from the source system. I hope this will solve my CR/LF problem. BRTina

Read up on how you might be able to handle that: Handling Flat Files with Varying Numbers of Columns.

Hello!The problemis Excel. If last column have values that are optional, all rows in the csv file will not have the same number of columns. My solution is to put a column with mandatory data last.Thanks for all help.BRTina

Create another flat file source having the same column as your flat file destination. Drag the red line from your actual fact file destination and drag it on to the new flat file source. A box will prompt you asking what you want to do with the error rows. By default, it is set as 'Fail Component'. Change it to 'Redirect Rows'. Now when you run the package, the error rows will automatically get filtered to this new file. Hope this works. Cheers, Deepak

I have same issue. When I am re-directing from source it is concatenating all source columns into single column and logging. Anyway to log separately?Porus