DTS connection failure error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

DTS connection failure error

Author

Topic

heliang
Starting Member

38 Posts

Posted - 2014-08-06 : 14:42:46

I have a DTS package stored in SQL 2005. It connects to a SQL cluster to process data weekly. I got lots of connection failure errors like below recently. Please help

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): Connection failure)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-06 : 14:54:55

You need to troubleshoot why the connection is failing. I would start by checking with your network administrator. Maybe you need to increase the connection timeout value if you have a slow network or slow servers.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

heliang
Starting Member

38 Posts

Posted - 2014-08-06 : 16:41:23

I have check the network. It shows that there is a tcp reset from SQL server, plus this is 1GB network. I do not believe there are anything wrong with network. I have changed the timeout value on SQL to 6000 which is 100mins already...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources