posted 1/15/2012 by ChrisAlbrektson - Views: [1201]
Below I will show you how BIxPress can protect sensitive information inside your SSIS packages such as passwords, connections strings, variables etc.
As you can see below I have an SQL configuration table that contains a variable I created for this demo. In the image you can see the configuration and the current value of my test variable. Since this is just a test variable it’s no big deal that anyone can see the configured value. In a real life situation this could be less than ideal and you may want to protect this sensitive information. This is where BIxPress can help solve this issue along with many others inside of SSIS.
The first step is to right click inside of the package and above the native configuration option inside SSIS you will see the package configuration wizard for BIxPress. Next you will need to click the check box to enable configurations and then the add button as shown below.
Next you will need to do the following. These steps are the same as you would when using the native tools inside of SSIS so that’s why I skipping over all the details here.
1. Enter a name for your configuration.
2. Select the SSISConfig connection in your package. This is needed so that package and read and write to the SSIS configuration table.
3. Select the appropriate configuration table if you have more than one.
4. Last but not least create a relevant name for your configuration filter and then click next.
The following 2 images are here to show you the different options available to you when using the Secure configurations. You have the options to pick which encryption mode you want and how complex you want BIxPress to create the algorithm.
These are the 5 mode you can choose from when setting up the encryption.
No Encryption
This option indicates its regular configuration and no value is encrypted. This is default option.
Encrypt Sensitive (Auto)
All password properties are encrypted automatically when you select this option. Any property without sensitive information is stored as plain text.
Encrypt Sensitive (Manual)
Password properties are encrypted when "Encrypt" column is checked for selected properties. Any property without sensitive information is stored as plain text.
Encrypt Full Value (Auto)
Encrypt full value of all configurable properties.
Encrypt Full Value (Manual)
Encrypt full value of configurable properties only when "Encrypt" column is checked
After you have selected the Mode and Algorithm that best meets your needs the last thing you need to do is select the check mark next to the value you want to encrypt then click next and start. Once you click start BIxPress will update your package. Now you can go back and review the configuration table and see how BIxPress has encrypted your sensitive information.
You might be asking yourself how all this works and that’s a valid question. When you clicked on the Start button to update your package BIxPress has created the needed event handlers inside your package that will decrypt the encrypted value from your configuration table.
For more info on this feature click here. For more info on BIxPress and it's other features click here.