Jordan2000 (3/11/2013)
Koen Verbeeck (1/28/2013)
If you don't have a lot of connections, I would set-up a configuration table and store the username and password there.That way you won't have to use a password to protect your package and so you can't make a typo 🙂
How do You read The config table? And use them in your connections?
Do you have ore can lead me to a sample ?
This article contains all the info you need:
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP