Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, ... Now when I execute my script task, it looks like Fig. 3. ... SQL Server MVP, ...

Now that we have variables in SSIS, you have to set up the script task to be able to use these variables. This works the same in 2005 and 2008, except in 2005 you have to type in the variable name ...