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.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.