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