November 27, 2013 at 2:03 am
Hello
We store our configuration files on a san drive and we use an indirect configuration so the packages access them via a unc path set in an Environment variable.
We are storing the configuration for the connection managers in the config files.
My question is what happens if a package runs when the san is not available? From my initial testing the package appears to still run but uses the setup from the package as it cant access the config file.
Is this as expected, or should the package end in error?
Many thanks in advance
David
November 27, 2013 at 2:46 am
This is as expected.
If a configuration fails, it throws a warning (not an error) and the package will continue with the design time values.
If you don't want this, you can put garbage in your connection strings right before deploying, so that the connection strings are invalid.
Configuration will overwrite these invalid connection strings and your package will run. If configuration fails, package will fail as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 4:12 am
OK, that makes sense. Thanks for clarifying.
David
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply