Getting Dynamic in SSIS Queries When you start working with SQL Server and SSIS, it won't be long before you find yourself wishing you could change bits of SQL queries dynamically.

NoSQL simply means Not Only SQL. Today most of the applications are hosted in cloud and that available through internet. They must support large number of users 24 hours a day, 365 days a year.

Now all we have to do is put this into a T-SQL query. Just create a second variable (I called mine Query) and build a dynamic string to concatenate your new date variable into your T-SQL code.