SSIS tip: Set variables’ values interactively in SSIS packages
Posted by Mohammed Mawla on Nov 11, 2009
This is a little tip for those who develop or debug SSIS packages.
In SQL Server Integration services, User namespace variables are assigned values that are used across the package.
When developing, testing or debugging packages, we assign multiple values to those variables to test different scenarios. This is done using the variables window.
However, SSIS Script tasks can allow us to key in values for selected variables in run time. This looks more fun and keeps us from taking chances when we forget assigning variables’ values.
A tiny example: Read the rest of this entry . . .
