BI Thoughts and Theories

A question that comes up occasionally is how to handle errors that occur on the OLE DB Destination in the data flow. Errors that occur when using the OLE DB Destination to insert into a table are usually caused by primary key, foreign key, or check constraints Read More...

Previously, I posted about how multiple errors in SSIS can be combined into a single unit for emailing or logging. Recently, a thread on the MSDN forums pointed out that the example wasn't quite complete. While it does show how to collect all the error Read More...

[edited on 12/14/2007 to correct an error in the text around string handling - the samples were not modified] One actual failure in SSIS can trigger a whole series of error messages. For example, failure to convert a column value from a string to an integer Read More...