在ssis中不同包装配置的优点/缺点是什么 [英] Whats are the advantages/disadvantages of different package configuration in ssis

问题描述

您可以解释SSIS包中各种配置（xml，环境变量等）的优点/缺点吗？

Can you please explain the advantages/disadvantages of various configurations (xml, environment variable etc) in SSIS packages?

推荐答案

您可以获得自己的结论这里

You can get your own conclusions here

但根据我的观点：

在SQL Server上有一个中央数据库表，其中配置条目可以存储和共享服务器和软件包。但是，您需要一种方法来告诉您的包服务器连接以获取配置。

On "SQL Server" you have a central database table where configuration entries can be stored and shared across servers and packages. BUT, you need a way to to tell your package which Server connect to get the configurations.

XML文件和环境变量是机器相关的，因此如果您有更多比起使用同一文件的一个包，您将有多个配置副本，每个机器一个副本，并且此配置不会集中。

"XML File and Environment Variable" are machine dependent, so if you have more than one package using the same file you would have multiple copies of the configuration, one for each machine, and this configuration would not be centralized.

您也可以有父

我真的更喜欢使用SQL Server，因为在生产环境中，访问到开发人员是非常有限的，你通常有读访问数据库，但你没有访问服务器是XML文件位于所以如果你需要检查一个配置值，你可以简单地运行一个选择对DB如果你使用的文件比较复杂。

I honestly prefer "SQL Server" because on a production environment, where access to developers is very limited, you usually have read access to the DB but you don't have access to the server were the XML file is located so if you need to check one configuration value you can simply run a select on the DB as opposed if you are using files its more complicated.

这篇关于在ssis中不同包装配置的优点/缺点是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！