Execute SQL Task in SSIS Full Row Set

Execute SQL Task in SSIS Full Row Set 7

How to return Full row set (or Complete Table) from the SQL server using the SSIS Execute SQL Task with an example. It will also demonstrate the Result Set option Full Row Set. For this, we are going to use the Employee table present in the SQL Tutorial database Before we start describing the Execute SQL Task in … 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