In this video we will learn how to save the query in a variable and then use in Execute SQL Task.
In this video you will learn following items
- How to Create SSIS Package from Scratch
- How to read list of Tables from a Flat File those need to be truncated from SQL Server Database
- How to Create String Type Variables in SSIS Package
- How to Write Expression on Variable to built SQL Statement
- How to use SQL Query ( Dynamic SQL) Saved in Variable in Execute SQL Task