Skip to content

Latest commit

 

History

History
45 lines (32 loc) · 2.2 KB

sql-server-faces-connectivity-issue-ssispack-fail.md

File metadata and controls

45 lines (32 loc) · 2.2 KB
Raw
title description ms.date author ms.author ms.reviewer ms.custom
Error 0x80004005 occurs when SSIS packages fail to run
This article helps you resolve the 0x80004005 error that might arise when you try to run SSIS packages by using the SQL Server Agent.
04/18/2024
prmadhes-msft
prmadhes
jopilov, haiyingyu, mastewa, v-jayaramanp
sap:Database Connectivity and Authentication

Connectivity error 0x80004005 occurs from SQL Sever Agent SSIS failures

This article provides a resolution to a connectivity issue in which SQL Server Integration Services (SSIS) packages that use an SQL Agent fail to run.

Symptoms

When you try to run SSIS packages that use an SQL agent, the packages don't run, and you receive the following error messages:

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "Protocol error in TDS stream".

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "Communication link failure".

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "TCP Provider: An existing connection was forcibly closed by the remote host".

Resolution

To resolve this issue, follow these steps:

  1. Open SQL Server Management Studio (SSMS), and then connect to your SQL Server instance.
  2. In the Object Explorer, navigate to SQL Server Agent.
  3. Locate your SSIS job that runs the package.
  4. Right-click the job, and then select Properties.
  5. In the Steps section, find the step that runs your SSIS package.
  6. Select the Edit button to open the Job Step Properties.
  7. In the Job Step Properties dialog box, navigate to Configuration > Connection Managers.
  8. Select the connection that's experiencing the issue.
  9. Change the value of the RetainSameConnection property from False to True.
  10. Select OK to save your changes.

Note

You can also adjust the RetainSameConnection property directly in the SSIS package connection manager properties.

See also

An existing connection was forcibly closed by the remote host (OS error 10054)