SSIS 2012 Variables window versus Locals window in debug

I have wasted most of this afternoon with a dumb problem.  I was testing some regular expressions, but for some reason the script task was not letting me break, so I create an SSIS variable (SSIS 2012) and made it read-write and assigned the value.  I then put a break on the PostExecute event.  I viewed the Variables window and noticed that the value didn’t change.  I tried everything to get the variable to change, even assigning a constant to the variable.  Nothing.

Finally, I opened the Debug, Windows, Locals panel.  I found my variable and saw that the value had changed.  I’m willing to bet that it had been changing all day long.

Moral of the story.  The Variables window is used to set and view the values at the beginning of the run of the package.  The Locals window shows the values as the package is running.

About Russ

Russ Loski is a data warehouse developer focusing on SSIS and SQL Server development. He has worked with SQL Server since 1998. He has used various technologies to move data from one source to others. He has worked for well-known companies such as the Bank of America, the Dallas Cowboys Football Club, T-Mobile and Coca Cola Enterprises. Currently he is developing a Data Warehouse for a large health care organization.
This entry was posted in Uncategorized. Bookmark the permalink.