How do you redirect the Entire record if a field causes an error to occur regardless of truncation or other error? Everything I have tried only redirects the error message, not the record that caused the error. I have a flat file source, I get a data conversion error in the source component, I want to redirect that 1 failed record to a flat file so I can look at it.John M. Couch

Check below thread i answered there http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/880a204f-c03c-4633-87c5-e78ced37b603Shailesh, Please mark the post as answered if it answers your question.

My error is occurring at the source, not at a data conversion step. As soon as I kick the data flow off, which it brings the record in to convert it from the flat file to the data type I specified in the metadata, it fails. The only output I can get from the error is the error itself redirected, it won't write out the record. John M. Couch

Go through this link which will help to you to get rows with individual column values. http://blogs.msdn.com/b/sqllive/archive/2008/01/01/sql-server-integration-services-enhancement-sql-server-katmai.aspx Shailesh, Please mark the post as answered if it answers your question.

while u redirect rows, configure Error Output settings as below: You will see the Error Output as below: Column 0,Column 1,ErrorCode,ErrorColumn 3,dgdfdgdgdfgfgdfgfdfgdfgdfgdgdfgdfdfgdfgdfgdfgdfg,-1071607680,92Please mark this post as answer if it resolves your Problem. You may even mark it as helpful. Thanks

Yes, i tried that, and it says it wrote 1 record out, but there is nothing in the file. And by nothing, I mean nothing at all. And no matter what I do to, this is the only configuration for the error output file I can get. The file I am importing has 240 fields. I want the entire record outputted, not the single column value that generated the error. John M. Couch

what is the behavior when no row is coming in error row ?? is package failing ?? you are re-directing row when there is error or truncation in only one column are you sure that column is only causing error? try to re-direct all columns in error output and checkShailesh, Please mark the post as answered if it answers your question.

I got it figured out. I had the output file set to overwrite on iteration. Thanks guys for the help.John M. Couch