Because the package container is at the top of the container hierarchy, variables with package scope function like global variables and can be used by all containers in the package. Similarly, ...

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit. While not a difficult task, the question of how to manipulate SSIS package ...

Let’s take a look… It’s simple enough to look at the variables in a package. Within the SSIS Designer, just click on the background of the Control Flow tab (to give focus to the package as a whole) ...

Leave the Senstive box unchecked for this and all other variables added in this module. Next, add two more variables with the following properties. Name Type Description Value TargetConnectonStr ...