配置对话框Configure Dialog Box

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

使用 “配置” 对话框可为包和项目配置参数、连接管理器和对环境的引用。Use the Configure dialog box to configure parameters, connection managers, and references to environments, for packages and projects.

您希望做什么?What do you want to do?

打开“配置”对话框Open the Configure Dialog Box

  1. SQL Server Management StudioSQL Server Management Studio中,连接到 Integration ServicesIntegration Services 服务器。In SQL Server Management StudioSQL Server Management Studio, connect to the Integration ServicesIntegration Services server.

    正在连接到承载 SSISDB 数据库的 SQL Server 数据库引擎SQL Server Database Engine 的实例。You're connecting to the instance of the SQL Server 数据库引擎SQL Server Database Engine that hosts the SSISDB database.

  2. 在对象资源管理器中,展开树以便显示 “Integration Services 目录” 节点。In Object Explorer, expand the tree to display the Integration Services Catalogs node.

  3. 展开 “SSISDB” 节点。Expand the SSISDB node.

  4. 展开包含您要配置的包或项目的文件夹。Expand the folder that contains the package or project that you want to configure.

  5. 右键单击该包或项目,然后单击“配置”。 Right-click the package or project, and then click Configure.

设置“参数”页上的选项Set the options on the Parameters page

使用 “参数” 页查看参数名称和值,然后修改值。Use the Parameters page to view parameter names and values, and to modify the values.

在“范围”下拉列表中,选择“参数”和“连接管理器”选项卡中显示的参数的范围。 Select the scope of the parameters displayed in the Parameters and Connection Managers tabs, in the Scope drop-down list.

以下是 “参数” 选项卡的选项列表。The following is a list of the options in the Parameters tab.

容器Container
列出包含参数的对象。Lists the object that contains the parameter.

名称Name
列出参数名称。Lists the parameter name.

“值”Value
列出参数值。Lists the parameter value. 单击省略号按钮可更改 “设置参数值” 对话框中的值。Click the ellipsis button to change the value in the Set Parameter Value dialog box.

以下是 “连接管理器” 选项卡中的选项列表。使用此选项卡可以更改连接管理器属性的值。The following is a list of the options in the Connection Managers tab. You use this tab to change values for connection manager properties. 将在 SSIS 服务器上为这些属性自动生成参数。Parameters are automatically generated on the SSIS server for the properties.

容器Container
列出包含连接管理器的对象。Lists the object that contains the connection manager.

名称Name
列出连接管理器名称。Lists the connection manager name.

属性名称Property name
列出连接管理器属性的名称。Lists the name of the connection manager property.

ReplTest1Value
列出分配给连接管理器属性的值。Lists the value assigned to the connection manager property. 单击省略号按钮可更改 “设置参数值” 对话框中的值。Click the ellipsis button to change the value in the Set Parameter Value dialog box. 您可以输入一个文字值、映射包含您要使用的值的环境变量,或使用包中的默认值。You can enter a literal value, map an environment variable that contains the value you want to use, or use the default value from the package.

设置“引用”页上的选项Set the options on the References page

使用 “引用” 页来添加和删除对环境的引用以及访问环境属性。Use the References page to add and remove references to environments, and to access environment properties.

环境可为已部署到 Integration ServicesIntegration Services 服务器的项目中包含的包指定运行时值。An environment specifies runtime values for packages contained in the projects you've deployed to Integration ServicesIntegration Services server.

环境Environment
列出环境。Lists the environment.

环境文件夹Environment Folder
列出包含环境的文件夹。Lists the folder that contains the environment.

打开Open
单击可打开“环境属性”对话框。 Click to open the Environment Properties dialog box.

“添加”Add
单击可添加对环境的引用。Click to add a reference to an environment. “浏览环境” 对话框中,单击一个环境,然后单击 “确定”In the Browse Environments dialog box click an environment and then click OK.

您可以选择 “SSISDB” 节点下的任何项目文件夹中包含的环境。You can select an environment contained in any project folder under the SSISDB node.

删除Remove
单击“引用”区域中列出的环境,然后单击“删除”。 Click an environment listed in the References area, and then click Remove.