Hi , I have created a SSIS package which have a Data Flow Control, which simply replicate a flat table from DB2 to SQL server database. I used Microsoft OLE Provider for DB2 as source connection. During off- hours replication has done sucessfully but during the transaction hours (Day-Time) following error is occurs in source . [OLE DB Source [1]] 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: "A TCPIP socket error has occured (10055): An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full. ". Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component,but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled. Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited. Could any one help me on this regards! Thanks Ashish Kumar MIshra

How much data do you transfer? Do you use fast load feature of OLEDB Destination control?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Uri, Thanks for reply. I am using Fast load option in Ole DB Destination and my table has about 14-Lacs Rows. Thanks Ashish Kumar Mishra