Execute SQL Task in SSIS Example

Execute SQL Task in SSIS Example 9

How to truncate the SQL tables using the Execute SQL Task in SSIS with an example. It also demonstrates the Result Set option NONE. For this, we are going to use the Employee table present in the SQL Tutorial database Execute SQL Task in SSIS Example Drag the Execute SQL Task from SSIS Toolbar and … Read more

Execute SQL Task in SSIS

Execute SQL Task in SSIS 10

The Execute SQL Task in SSIS is used to run SQL queries (statements) or stored procedures from the SSIS package. You can use this SSIS Execute SQL task to write the single SQL statement or multiple SQL statements that can run sequentially. We can use this SSIS Execute SQL Task for the following purposes: Create, Alter, and … Read more