如何创建范围为 EnvVariable 的变量? [英] How do you create a variable of scope EnvVariable?

问题描述

如何创建范围为 EnvVariable 的变量，如此屏幕截图所示

How do you create a variable of scope EnvVariable as shown in this screenshot

这个 StackOverflow 答案?

of this StackOverflow Answer?

推荐答案

范围通常表示 Package 名称或 Control Flow 任务 名称.在这种情况下，EnvVariable 表示包名称.请参阅屏幕截图 #4.要创建变量，请按照以下提到的步骤操作.

The scope usually represents the Package name or a Control Flow task name. Here in this case, EnvVariable represents the package name. Refer screenshot #4. To create a variable, follow the below mentioned steps.

1. 右键单击包并选择Variables.请参阅屏幕截图 #1.
2. 在 Variables 窗格中，单击第一个图标以创建变量.请参阅屏幕截图 #2.
3. 默认情况下，变量将命名为Variable.将名称更改为 FilePath.
4. 默认情况下，变量数据类型为 Int32.将数据类型更改为字符串.
5. 您还可以从 SSIS 菜单 --> Variables 访问变量窗格.确保您点击了包裹.否则，选项将不可见.请参阅屏幕截图 #3.

1. Right-click on the package and select Variables. Refer screenshot #1.
2. On the Variables pane, click the first icon to create a variable. Refer screenshot #2.
3. By default, the variable will be named Variable. Change the name to FilePath.
4. By default, the variable data type will be Int32. Change the data type to String.
5. You can also access the Variables pane from SSIS menu --> Variables. Make sure that you click on the package. Otherwise, the options won't be visible. Refer screenshot #3.

希望有所帮助.

屏幕截图 #1:

屏幕截图 #2:

屏幕截图 #3:

屏幕截图 #4:

这篇关于如何创建范围为 EnvVariable 的变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！