大网数据广告活动
数据库与应用安全

Error 0x80004005 When an SSIS Package Fails to Run as a SQL Agent Job

· 52CE 我爱测

This article helps you resolve the 0x80004005 error that might arise when you try to run SSIS packages by using the SQL Server Agent.

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

Symptoms

When you try to run an SSIS package as a SQL Server Agent job, the package doesn'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)

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: prmadhes-msft). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 03/11/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。