如何修复导致程序包在生产中失败的连接管理器错误？

I have created an SSIS package and it works great on my dev machine. But, when I try to run it on the production server, it errors out on me.

我已经创建了一个SSIS包,它在我的开发机器上运行良好。但是,当我尝试在生产服务器上运行它时,它出错了我。

Here is the error:

这是错误:

Error: The AcquireConection method call to the connection manager 
"DestinationConnectionOLEDB" failed with error code 0xC0202009.

I have figured out the cause, but am not sure how to get it fixed. The password isn't in the connection string. But I have set the password in the SSIS project. For some reason though, when I deploy and run this on the production server, it won't run since the password isn't part of the connection string.

我已经找到了原因,但我不确定如何解决它。密码不在连接字符串中。但是我在SSIS项目中设置了密码。但是出于某种原因,当我在生产服务器上部署并运行它时,它将不会运行,因为密码不是连接字符串的一部分。

Is there some setting in the SSIS project that I need to change in order to get this to work right?

我需要更改SSIS项目中的一些设置才能使其正常工作吗?

Thanks.

1 个解决方案

#1

Disable the password by setting the ProtectionLevel in the package properties to DontSaveSensitive.

通过将包属性中的ProtectionLevel设置为DontSaveSensitive来禁用密码。

I also recommend moving the connection string to a package variable and make an expression on the connection. Enable package configurations.

我还建议将连接字符串移动到包变量并在连接上创建表达式。启用包配置。

Then you are free to change the connection and to use integrated security or not without changing the package. You can either put the connection string in the configuration or then provide it on the command line.

然后,您可以随意更改连接并使用集成安全性,而无需更改软件包。您可以将连接字符串放在配置中,也可以在命令行中提供它。

#1