July 14, 2011 at 3:05 am
Hi All,
Background: I've got a dtsx with all the connection strings in a sql table except one which is in a xml config file. The one in the xml config file points to the database where the rest of the connections are.
My problem is that I want my dtsx file to have no default connection strings in it. It should just get them from the config file. Does anyone know a way of getting SSIS to remove the default connection strings? I know I can edit the dtsx file directly and delete them out or possibly use an xml editing tool but was looking for an SSIS method.
The reason for this is that I can keep exactly the same dtsx file in all environments and just change the XML config file it points to. The default connection strings end up in prod environments even if there never used and if someone deleted the config file for whatever reason they would be used...!!!
Any ideas?
July 14, 2011 at 4:33 am
In Denali this will be easy, but for the moment you can't tell SSIS to ignore the design-time default.
You could set all the connection managers to invalid connections, so that if for some reason the config file doesn't load, the package can't run.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2011 at 9:24 am
cheers
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply