I'm reading this
http://technet.microsoft.com/en-us/library/ms141679(SQL.90).aspx but I don't quite understand about the Error Output option "Redirect Row", the error or the truncation data row is directed to the error output of the source, transformation,
It sounds to me that the error will be output to somewhere but how I know where. In the Advance Editor for Destination, I find the Input and Output Properties and it has Output Columns under OLE DB Destination Error Output.
For example, if I set the Error Output option to "Redirect Row" for a Destination component, what does it mean?
Is there any article which shows an example of "Redirect Row"?
View Complete Post