SQL Server Performance

DTS Task Failed...

Discussion in 'SQL Server DTS-Related Questions' started by ramkumar.mu, Dec 6, 2007.

  1. ramkumar.mu New Member

    Yesterday a DTS package failed with the following error...
    ------------------------------------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) (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
    -----------------------------------------
    I couldnt find this type of error (Connection failure) in google and microsoft kb. Can you please help?
  2. ranjitjain New Member

    Hi,
    As per the error, it looks like during execution of step, task must be using connection object and trying to establish a connection with sql server over OLEDB. For some reason connection could not be established and package is throwing that error, reasons could be, SQL server service is stopped or restarted, may be it's not accepting any remote connections, Look at the connectionstring and try to connect the same server from QA

Share This Page