Date: 03 Dec 2004
Have you noticed that variables in IS have a scope? Your first encounter will probably be something along the lines of "%!*$%, where has that variable gone", before you realise that you created the variable in a scope other than the package. So what does the scope really mean and how is it used?
This blog post by Kirk Haselden from the SQL Server Integration Services team talks you through some of the reasoning behind the introduction of scoped variables, and most importantly what you need to know about them and how it can affect you use of variables in your IS packages.