Long time reader... first time poster.

I was receiving this error from an SSIS Package after a data source server was upgraded to SQL 2005.

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

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

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: The specified network name is no longer available.

".

I seem to have resolved it by forcing the package to use TCP/IP instead of Named Pipes.

On the first attempt I used the SQL Server configuration manager to create the alias. The package still used Named Pipes. My new Management Studio connections began using TCP/IP.

On the second attempt I used the cliconfg utility (start -> run -> cliconfg) and created the alias. (note : the alias created in SQL Config manager did not appear here). Within a few moments I could see the switch from the named pipes network library to the TCP/IP network library when querying the master..sysprocesses table for the SPID in question.