带花括号的 Sql 代理作业 SSIS 包参数值会导致 SqlManager UI 出错 [英] Sql Agent Job SSIS Package Parameter value with curly brace causes error with SqlManager UI

问题描述

我有一个 SSIS 包部署到 SSISDB 目录.该包可配置参数值，例如 FTP 详细信息.

我注意到，当任何参数值包含左花括号 {

时，尝试为此包创建 SQL 代理作业失败

不幸的是，其中一个密码参数包含一个左花括号.

问题是:如果不诉诸于替换实际包中该字符的占位符(感觉很脏)，是否可以转义此字符或以允许左花括号的不同方式保存作业?

这是您在尝试保存代理作业步骤时收到的错误消息的图像.

服务器是 SQL Server 2014.

解决方案

SSIS 2012 和更新版本似乎对包含特殊字符(如左花括号)的敏感包参数存在问题.一个可行的替代方法是将敏感字符串作为变量放在相应的环境中，然后按照

然后，在那里配置包含违规字符的敏感字符串变量
并在包中添加对环境的引用.

最后，在 Job 的 Configuration 选项卡上，选择环境，并使用环境变量.

I have a SSIS package deployed to the SSISDB catalog. The package is configurable with parameters for values such as FTP details.

I have noticed that attempting to create a SQL agent job for this package fails when any of the parameter values contains a left curly brace {

Unfortunately, one of the password parameters contains a left curly brace.

The question is: without resorting to replacing place holders for that character in the actual package (feels dirty), can this character be escaped or the job saved in a different way that will allow left curly braces?

Here is an image of the error message you get when attempting to save the agent job step.

The Server is SQL Server 2014.

解决方案

SSIS 2012 and newer seems to have a problem with Sensitive Package Parameters that contain special characters like a left curly brace. A workable alternative is to put the sensitive strings as Variables in a corresponding Environment and load the values from there as suggested by Jeremy J here.

First, create a new Environment in the Integration Services Catalog on an existing SSISDB/{Project?}/Environment node

Then, configure the sensitive string variable that contains the offending character there
and add a reference to the Environment in the Package.

Finally, on the Configuration tab of the Job, select the environment, and use the environment variables.

这篇关于带花括号的 Sql 代理作业 SSIS 包参数值会导致 SqlManager UI 出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！