DTS connection failure

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

    Step XXX Failed

    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

  • Do you have any errors on the SQL cluster at those times? Is this an intermittent problem or does it happen every time the package runs? Have you tested the package in BIDS and seen the same problem?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply