Eirikur Eiriksson (5/5/2014)
Further on what Koen said, you will have to test explicitly for the existence of the config file, common method is to have a variable with lets say 0 value in the design environment and another value in the config. There are smarter ways but this is simple and works.😎
Exactly. I use _notValid for string variables. If you encounter an error somewhere with _notValid in the error message, you know the configuration has failed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP