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/
Go to Top of Page

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...
Go to Top of Page
   

- Advertisement -