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

Error loading when you run Integration package

· 52CE 我爱测

This article helps you resolve package load failures that occur when SSIS cannot decrypt the password stored in the package.

This article helps you resolve package load failures that occur when SSIS cannot decrypt the password stored in the package.

Original product version:   SQL Server
Original KB number:   904800

Symptoms

In Microsoft SQL Server, when you try to run a SQL Server Integration Services (SSIS) package from inside Microsoft SQL Server Business Intelligence Studio or by using the SQL Server Execute Package Utility (Dtexec.exe) command-line tool, you receive the following error message:

Error loading PackageName: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state."
You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

Note: The PackageName placeholder is a placeholder for the name of the SSIS package that you are trying to run.

This behavior occurs when you try to run the SSIS package by using a different computer or a different user account than the computer and user account that were used to create the SSIS package.

Cause

This behavior occurs if the value of the ProtectionLevel property in the SSIS package is set to provide the maximum amount of protection for the Password property in the SSIS package. By default, the value of the ProtectionLevel property is set to EncryptSensitiveWithUserKey. The EncryptSensitiveWithUserKey value encrypts all the properties of the SSIS package that are considered sensitive, such as the Password property. When the same user account and the same computer that were used to create the SSIS package are used to run the SSIS package, the SSIS package automatically decrypts, and no error message is generated. However, when a different user account or a different computer is used to run the SSIS package, the EncryptSensitiveWithUserKey value of the ProtectionLevel property is engaged, and the Password property of the SSIS package remains encrypted. When this occurs, an error message is generated.

Resolution

To resolve this behavior, change the value of the ProtectionLevel property in the SSIS package.

More information

For more information, see the following topics in SQL Server Books Online:

  • Security Considerations for Integration Services
  • Setting the Protection Level of Packages

References

For more information about a similar problem, see SSIS package does not run when called from a SQL Server Agent job step.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. 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 09/02/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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