Help! - Error in moving data from AS400
I have a process that simply copies data from a table on an AS400 to SQL Server. This process executes fine until it gets to around 44 million rows copied out of 48 million rows in the source table. At this point, the process exits with the following error messages:
The attempt to send a row to SQL Server failed with error code 0x80004005.
The ProcessInput method on component "SQL Server Destination" (40) failed with error code 0xC02020C7.
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.
Thread "WorkThread0" has exited with error code 0xC02020C7.
The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Thread "SourceThread0" has exited with error code 0xC0047038.
I am using the Microsoft OLEDB Provider for DB2 to access the AS400 and have tried the Table/View and SQL Command access modes with the same result.
Any help will be Greatly Appreciated!
-Mark Redman.
