We are using SSIS for some data migration work. For sake of convenience , we are using C# code to generate SSIS package and execute it. Now when calling Package.Execute() method in , if there is some error raised by Ado.Net driver used in source component SSIS is supposed to catch the error and report it back but its not doing that and its finishing package execution with success status even though some rows were not transferred due to that reason. To be specific when SSIS was calling IsDBNull method of third party driver used in ADO.Net provider for columns of type 'Image' it was throwing exception and not transferring those rows .That is anyways issue with third party driver but we have no clue when driver is throwing clear exception why SSIS silently keeps transferring rows without raising any error? and because of that, in the end some rows are missing and still package status is executed successfully without any warning or error. Also to isolate this issue from driver we even created proxy classes inheriting Ado.Net provider,say its our custom ADO.Net driver plugged in SSIS Ado.Net source component,that was in turn forwarding calls to third party driver.Now we explicitly raised exception in our custom provider when it calls GetData() but SSIS is suppressing it and keeps moving forward (we could see it raising exception in visual studio in debug mode when SSIS was calling it). So it looks like for some reason SSIS suppresses any exceptions raised by driver used in ADO.Net provider. So is there any specific reason for such behavior or we should consider it as SSIS bug?

I do not know how you designed the package, are you calling another package from a master package? Try to make sure the Propagate system variable is properly set in your C# code. Some more info: http://simonworth.wordpress.com/2009/11/11/ssis-event-handler-variables-propagate/Arthur My Blog