August 6, 2014 at 12:47 pm
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
August 7, 2014 at 10:43 am
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?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply