• 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 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP