更新时间:2021-12-15 08:14:45
这是错误的,因为您试图触摸标记为敏感的参数.您不能使用旧"方法来配置连接管理器.对于项目部署模型和连接管理器,在 SSISDB 中,右键单击项目并选择配置.
It is erroring because you are trying to touch a Parameter that is marked as Sensitive. You cannot use the "old" approach for configuring connection managers. For the project deployment model and Connection managers, in the SSISDB, you right click on the project and select Configure.
您可以在此处覆盖密码.
There is where you overlay a password.
否则,您需要使用 GetSensitiveValue
方法来访问该值,而不是使用标准的 Getter 属性.
Otherwise, you then need to use the GetSensitiveValue
method to access the value instead of the standard Getter property.
Dts.Variables["$Package::FtpPassword"].GetSensitiveValue().ToString();
参见马特的文章 在脚本中检索敏感参数的值