We are migrating a few DataStage jobs to SSIS 2008 and below is an issue that is bothering me.
I am trying to use the FastLoad option of the Microsft OLE DB Provider for DB2 v3.0 but have been unsuccessful. I am trying to run a simple package that loads the data from one DB2 table to another without any transformation.
The reason I am exploring the fast load is because the normal option of OpenRowset does not perform as well the DataStage job to load the same amount of data, its almost 10 times slower.
DB2 version 9.5 Fixpack 5
[OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE: HY000, SQLCODE: -379".
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (79) failed with error code 0xC0202009 while processing input "OLE DB Destination Input" (92). The identified component returned
an error from the ProcessInput method. The error is specific
View Complete Post