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
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.