please define capture.

I have attached a simple screen shot. Basically put a flat file or OLEDB destination in the data flow , click on the derived column and drag it over to the destination. Then set it to pass the error to destination for Error or truncation. So when thee cast fails it goes down this route. You can also include a rowcounter on the way so the package knows how many rows have errored.

Hope that helps.

E

And if you want something snazzier there are a few custom tasks about such as XMLify that take all of the columns passed to the task and slap it into one chunk of XML and then you have one generic error table.