ssis中的环境变量配置是什么，ssis中的注册表项配置是什么 [英] what is environment variable configuration in ssis and what registry entry configuration in ssis

问题描述

我正在学习SSIS.现在，我受制于配置.我已经完成了xml，父程序包和SQL配置，但是我不了解什么是SSIS中的环境变量配置和注册表项配置.

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I am not understanding what is Environment Variable configuration and what is registry entry configuration in SSIS.

推荐答案

环境变量配置意味着您要配置SSIS包中的变量以从环境变量.环境变量在计算机/服务器/系统级别设置.

The Environment Variable configuration means that you want to configure your variable(s) in the SSIS Package to take the value from an Environment Variable. Environment Variables are set at the Computer / Server / System level.

例如，您可以将数据库的连接字符串存储在环境变量中，并配置在该服务器上运行的所有程序包，并使用该数据库从该变量中获取连接字符串值.

For example, you could store the connection string for a database in an environment variable and configure all your package that run on that server, and use that database, to take the connection string value from that variable.

与注册表配置"设置相同，在此注册表项中包含SSIS变量值.

Same with Registry Configuration setting, where you have Registry keys that contain your SSIS variable values.

有关所有配置类型的详细说明，请参见下面的MSDN文章.

See the following MSDN Article for detailed explanation on all the configuration types.

我知道开始使用SSIS时会有些困惑:)我也遇到了同样的问题.

I know SSIS tends to be a little confusing when you get started :) I went through the same issues.

这篇关于ssis中的环境变量配置是什么，ssis中的注册表项配置是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！