Execute SQL Task in SSIS Full Row Set

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 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 queries (statements) or stored procedures from the package. You can use this SSIS Execute SQL task to write the single statement or multiple statements that can run sequentially. We can use this SSIS Execute SQL Task for the following purposes: Create, Alter, and drop the tables and … Read more