SSIS包运行出错信息:
Code:
0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTS:Password" 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.
出错原因:
包的保护级别默认为 EncryptSensitiveWithUserKey。此设置可以保证只有开发人员可以看到包中的敏感值(如密码、 用户名和连接字符串的属性)。但部署包到服务器后,需要将保护级别更改为不依靠开发人员用户密钥的保护级别。因此,通常需要选择EncryptSensitiveWithPassword 或EncryptAllWithPassword。通过分配一个生产环境中运营团队也知道的临时强密码来加密包。</