ssis xml configuration modifies package xml - am i crazy?

1
votes

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

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.

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

1
sql-serverssis

1 Answers

3
votes

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.