Hi all,

i am looking for solution for "Communication link failure"  since many months in google but no luck, am running an SSIS package to load data. job failing many times with error 'Communication link failure', searched every where but found nothing. Below is the complete error description when job failed, can any one let me know how to resolve / suggestions or any ideas about issue.

OS - Windows server 2008 R2 Enterprise Edition

RAM - 198GB

 SQL server 2008 R2 Enterprise Edition and error description is below,

Started:  6:22:40 AM  Error: 2015-08-19 18:50:32.70     Code: 0xC0202009     

Source: Data Flow Task Lookup [193]     
Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. 
Error code: 0x80004005.  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  
Hresult: 0x80004005  Description: "Communication link failure".  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  
Description: "Communication link failure".  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  
Hresult: 0x80004005  Description: "TCP Provider: An existing connection was forcibly closed by the remote host.  ".  End Error  Error: 2015-08-19 18:50:32.80  Code: 0xC020824C     

Source: Data Flow Task Lookup [193]     
Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
Code: 0xC0208235     

Source: Data Flow Task Lookup [193]     
Description: Unable to locate reference column "lkey".  

End Error  Error: 2015-08-19 18:50:32.81     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     
Description: component "Lookup" (193) failed the pre-execute phase and returned 
error code 0xC0208235.  End Error  DTExec: The package execution returned 
DTSER_FAILURE (1).  Started:  6:22:40 AM  Finished: 6:50:38 PM  Elapsed:  44877.7 
seconds.  The package execution failed.  The step failed.

Regards,

Syed Jakeer

• Merged by Katherine XiongMicrosoft contingent staff, Moderator 4 hours 44 minutes ago duplicate

Hi all,

i am looking for solution for "Communication link failure"  since many months in google but no luck, am running an SSIS package to load data. job failing many times with error 'Communication link failure', searched every where but found nothing. Below is the complete error description when job failed, can any one let me know how to resolve / suggestions or any ideas about issue.

OS - Windows server 2008 R2 Enterprise Edition

RAM - 198GB

 SQL server 2008 R2 Enterprise Edition and error description is below,

Started:  6:22:40 AM  Error: 2015-08-19 18:50:32.70     Code: 0xC0202009     

Source: Data Flow Task Lookup [193]     
Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. 
Error code: 0x80004005.  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  
Hresult: 0x80004005  Description: "Communication link failure".  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  
Description: "Communication link failure".  An OLE DB record is available.  

Source: "Microsoft SQL Server Native Client 10.0"  
Hresult: 0x80004005  Description: "TCP Provider: An existing connection was forcibly closed by the remote host.  ".  End Error  Error: 2015-08-19 18:50:32.80  Code: 0xC020824C     

Source: Data Flow Task Lookup [193]     
Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
Code: 0xC0208235     

Source: Data Flow Task Lookup [193]     
Description: Unable to locate reference column "lkey".  

End Error  Error: 2015-08-19 18:50:32.81     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     
Description: component "Lookup" (193) failed the pre-execute phase and returned 
error code 0xC0208235.  End Error  DTExec: The package execution returned 
DTSER_FAILURE (1).  Started:  6:22:40 AM  Finished: 6:50:38 PM  Elapsed:  44877.7 
seconds.  The package execution failed.  The step failed.

Regards,

Syed Jakeer

You need to look at the last error.  Your true error is:

Source: Data Flow Task Lookup [193]     
Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
Code: 0xC0208235     

Source: Data Flow Task Lookup [193]     
Description: Unable to locate reference column "lkey".  

You have an invalid column reference in your query.

Hi, thanks for reply, same package running since 18 months and no code changes at all. job failed after 12 hrs and reported above error, I've verified everything and seems good. generally job take 07 hrs to complete. 

Regards,

Syed Jakeer

Hi Syed,

Since you say that the issue is suddenly, it looks like it is a network issue or connection issue. Please check your firewall setting or network load, and if you have the same problem with correct version provider or other providers.

Another possible reason for this issue is SNP features (TCP Offload, RSS) is enabled on the server. To disable the TCP Offload and RSS features, please see the following KB articles:
http://support.microsoft.com/kb/951037
http://support.microsoft.com/kb/948496

References:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c/communication-link-failure-when-connecting-to-remote-database
https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx

Thanks,
Katherine Xiong