Connection errors

Last Post 08 Jul 2011 07:36 AM by PaulMcKibben. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
07 Jul 2011 12:59 PM
I have a developer who is writing a package using BIDS 2008.  The package is loading a SQL 2005 database.  The packages truncate the tables and reload them. 

What the developer is receiving is the following:

[comm_dashboard_err_db [33]] Error: 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: "TCP Provider: An existing connection was forcibly closed by the remote host.

".

[comm_dashboard_err_db [33]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (46)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (46)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

The process is that a text file is the source that loads a work database, then the work database is used to load the final database.

The provider that she is using for the databases is the Native OLE DB\SQL Server Native Client 10.0.  

Any assistance would be appreciated.
Thank you, 


rm
New Member
New Member

--
08 Jul 2011 04:32 AM
Is connection setting in the package correct?
PaulMcKibben
New Member
New Member

--
08 Jul 2011 05:58 AM
Yes, the server and database names are correct.
rm
New Member
New Member

--
08 Jul 2011 06:03 AM
PaulMcKibben
New Member
New Member

--
08 Jul 2011 06:30 AM
Windows 2003
rm
New Member
New Member

--
08 Jul 2011 07:35 AM
Checked above link? Specifically for win2k3.
PaulMcKibben
New Member
New Member

--
08 Jul 2011 07:36 AM
Yes I did. Thank you.
You are not authorized to post a reply.

Acceptable Use Policy