Hi All, I have a package that transform data from OLEDB Source TableA to OLEDBDestination TableB. The count of records in TableA is around 7.500.000 records. When I run that package, the package run well, but after around 200.000 records have been inserted to TableB, the package got error, and TableA become Red. This is the summary of the error messages : Unspecified error SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Union All 11" (16989) failed with error code 0xC0047020 while processing input "Union All Input 2" (17111). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020 I've tried to search that problem, and I read in forum that someone suggest to change the Data Access Mode for OLEDB Destination From "Table/View Fast Load" to "Table/View". I've tried that, but the performance become very slow, and I still got the same error after around 300.000 records have been inserted to TableB. Does anybody know what reason that might cause that error? Thank you

where did you got this error? on source? destination ? or transformation? you should configure error output on any component which caused error, and redirect error output to another flat file destination, then you can run the package, and take a look at bad data rows in flat file to troubleshoot problemhttp://www.rad.pasfu.com

You need to post all of the error messages you receive in the Output window - not just one of them. The error you've posted relates to a Union All component, which I'm quite certain isn't related to your actual problem. Talk to me now on