Custom Password Protection for SSIS Packages

Overview

When working with data sources that use SQL Server authentication, the Jet Data Manager (version 16.2 and higher) allows you to supply a custom password to protect SSIS packages. Sources that use Windows authentication do not require encrypted SSIS packages.

Process

SSIS packages that contain SQL Server logins are encrypted using a password.  The Jet Data Manager (JDM) uses a default password to protect packages generated by the JDM. In JDM 16.2, we have added the ability to set a custom password, which is useful in connection with the Customize Code feature.

When you use Customize Code to add a custom SSIS package to a table, you can type the password you wish to use or simply use the default password.  When you have edited the SSIS package and the JDM loads it back into the project, you also have the option to type in a password in case you have changed it outside of the JDM.

If you wish to change the default password, you can do this in Edit Project. Right click your project in the project tree, and click Edit project. You can find the setting under the “Deployment” header.