SSIS Package Configuration using Registry Entry

Windows registry is another mode to store package configuration values. The package configuration value can be stored either in an existing registry key or in a new registry key created. It can further be changed to different values of the key if required at a later point in time.

Create a new key in HKEY_CURRENT_USER section of the registry. Go to registry editor and create a new key.

Below are the steps to create a registry key.

Go to run and write Regedit and press enter.

The window will be open

                              

Now we are creating the registry key value.

Expand the HKEY_CURRENT_USER then right click Go to New then choose Key in order to create a new key. We could also use any existing key but for clear understanding let's create a new one.

                    
Click on the Key.

Creating a folder named “SSIS_Variable”

                         
Now we need to create string value.

            
A new string value is created and we need to modify the key value and assign the value.

    
Click ok

  

Registry variable is created.

Now we are creating the package where we user registry configuration.

We are creating a variable   

Taking the script task to show this value.   

Now executing this package.  

Now we are creating the configuration.   

Select the Configuration type as “Registry entry” and write the name of the Registry folder which we have created above and click next  

Select the variable value and click ok.

Now we are ready to run this package.

 

Here we are getting the value from the registry.

Points to be remember

 Ø  Registry entry configuration value can be stored either in an existing registry key or in the new registry key created.

Ø  This configuration type in SSIS used very rarely.

Ø  It should not use to store the database name or any user credentials if there is any security concern.

Ø  At the time of deployment same registry entry key must be available with the appropriate value data.

Ø  Only a single value can be stored in one registry key.