SSIS - Use Variable in Execute SQL Task ( Update Statement )

Scenario : 

We have saved some value in one of the variable in our SSIS Package, now we need to use this variable in Execute SQL task to update values in Table.

Solution : 

Step 1: 
Create a variable ClientType as shown below

Step 2: 
Create connection as shown in below and write query. The ? is used to map the value of a variable.

Lets map the variable

Run the package and it should update values in table with variable value.

1 comment: