Execute SQL Statement | Using Variable in Parameter Mapping | Dynamically
Execute SQL Task in SSIS
The Execute SQL Task in SSIS runs queries (statements) or stored procedures from the package. You can use this Execute SQL task to write single or multiple statements that can run sequentially.
This video helps to Execute SQL Task in SSIS by passing Variable to the Parameter Mapping and we are going to perform the below steps to achieve this.
1.Create variable and define the value to the variables
2.Do the Parameter mapping by using newly created variables to perform the SQL Insert operation
3.Check the data loaded or not into the target table once ran the Package