Execute SQL Task in SSIS Example

How to truncate the 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 database Execute SQL Task in SSIS Example Drag the Execute SQL Task from SSIS Toolbar and drop it into … Read more