SSIS Packages

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