Marc M-454371 (9/25/2013)
Gotcha. Makes Sense. Thanks for the clarification.Does it make sense that I would want to "XXXXXX" out the value stored in the packages (either in variable or coded in the connection) when being saved to either LIVE or QA? My concern is having a package saved in QA pointing to LIVE.
I have noticed "XXXXX"ing out the Server Variable that talks to the Connection slows things down when opening in the VS Designer.
I guess its a Pros vs Cons scenario.
It makes sense to have "XXXXXX" if the configuration is missing, to make sure you don't mess up another environment.
However you should have a configuration for the development environment as well, otherwise you get the time-out delays you experience when opening the package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP