SSIS Packages
July 9, 2013 Leave a comment
Dear Future Jamie:
If you have to set up a SSIS package in the future and you need to use non-integrated security – you can’t save the password in the package itself. You need to create a .config file and place it on a central location on the data server. You can then enter in the Password into that file and the job will run.
Love Current Jamie