• Hadrian (12/1/2015)


    Hello experts,

    I have a job which execute a SSIS package and since two intermittently failed with this horrible message :

    Source: Update_ReportServerLog Connection manager "ReportServer" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. (is in DMZ env)

    Maybe someone help me with this urgent matters

    Thanks,

    Hadrian

    I can't say anything about the SSIS part; I'll leave it to someone who knows SSIS to post on that. Take a look at your error messages. What changed since the job worked?