ssis xml 配置修改包 xml - 我疯了吗? [英] ssis xml configuration modifies package xml - am i crazy?

问题描述

SSIS XML 配置真的可以改变包的内容吗?

Can SSIS XML configuration actually alter the contents of a package?

我创建了一组连接到本地机器的包，并运行了它.然后我创建了 XML 配置然后我修改了 dtsconfig XML，将 ConnectionString 中的 DataSource 和 ServerName 也更改为第二台服务器.

I created a set of packages connecting to my local machine, and ran it. Then i created XML configurations then i modified dtsconfig XML , changing the DataSource in the ConnectionString and the ServerName as well to a second server.

我遇到了登录错误，所以我查看了我的包的代码.包中的连接管理器现在拥有第二个服务器，而不是我在包中编码的本地主机连接.我绝对确定我没有修改包中的连接管理器，只是修改了配置.

i was getting login errors so i viewed the code of my packages. the connection managers in the packages now had the second server, not the localhost connection i had coded in the package. I am absolutely certain that i did not modify the connection managers in the package, only the configuration.

所以我的问题是，SSIS 配置可以更改包本身吗?

So my question is, can SSIS configurations change the package itself?

推荐答案

如果你在设计时指定了一个配置文件，然后运行你的包，你的设计时对象的属性将被更新(在你的设计时包中) 到您的配置中指定的值.

If you specify a config file at design time, then run your package, the properties of your design-time objects will be updated (in your design-time package) to the values specified in your config.

如果您随后保存您的包，它将与更新的属性值一起保存.

If you then save your package, it will be saved with the updated property values.

这篇关于ssis xml 配置修改包 xml - 我疯了吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！