Marc M-454371 (9/25/2013)
Grasshopper. Thanks for your post!I agree with your approach but I am starting to get a bit confused as to what my best set up should be.
My LIVE environment consists of 2 servers (A_Live and B_Live .... A_QA and B_QA).
Prior to your post, I have the XML file on each server pointing to a CONFIG table on the appropriate environment. This table will then set the connections based on their names and the Configuration_Filter field.
Are you suggesting that I do not use a SQL Server Configuration Table and strictly rely on Variables (varServerA and varServerB) to set the connections appropriately?
Sounds simple. I would just need an XML file on each server with the two variables with the appropriate values.
You can still use the SQL Serve config table (indirect configuration), but instead of directly configuring the connection managers, you configure variables instead.
These variables are in turn used in expressions on the connection managers.
But, as you said, you can do this directly in the XML config file (direct configuration)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP