Reading Sensitive Parameters in SSIS Data flow

If you ever used ZappySys SSIS PowerPack you will notice that using Sensitive Parameters can be used inside Control Flow Tasks but not in Data Flow Components. This is due to limitation imposed by SSIS Framework. It doesn't allow to read Sensitive Parameters inside Data Flow. But don't worry workaround is easy using FREE SSIS Task called Logging Task.

In this post we will see how to use Sensitive Parameter in SSIS Data flow component like JSON Source. Reading Sensitive Parameter in Data Flow requires two steps (First read parameter and save to local variable, then use it in second step inside data flow)

Here is how to use Sensitive Parameters in Data Flow.

1. Define Sensitive Parameter in SSIS (Package Level or Project Level)

Here is how you can define Sensitive Parameter in SSIS

2. Reading Sensitive Parameter in SSIS and Set Variable

Now as we discussed earlier, there is no direct way to read Sensitive Parameters in SSIS Data flow but indirect trick is easy. You have to use FREE Logging Task. In our example we have mixed String with Placeholder (i.e. Sensitive Parameter). You can use just parameter name in Text area. At runtime parameter value is replaced and assigned to variable Selected (i.e. varJsonString in our case). Later you can use this variable in Data Flow or Control Flow.

Using Variable in Data Flow (Sensitive Parameter Value)

Here is how we can use variable set earlier which holds value of sensitive parameter. 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/