How to check SSIS Variables values at debugging runtime

In this tutorial we describe Step by step How to check SSIS Variables values at debugging runtime   in Sql Server Integration Services .
We'll see here in just 5 minutes how to watch SSIS variables values at debugging, distinguishing between those at Foreach Loop Containers and those at Data Flow Tasks , using the following SSIS application:

How to check SSIS Variables values at debugging runtime

In the snapshot below can be seen the guiding principles of runtime variables checking  at an "Foreach Loop Container" :

First, select the SSIS flow item where you want to watch the variables.
Remember that variables have a scope, therefore you must check that that scope includes the selected item.
For this example, we'll start with a Data Flow Task .
Once you decided what flow item to watch, right click the mouse on it, and click the "Edit Breakpoints" menu item:

Then, select the Break condition to stop the runtime . It can be the On PreExecute event, or any of the Events that you see on the snapshot below:





In the case of a Foreach Loop Container, it is advisable that you spot the variables at the beginning of every loop iteration . Therefore select from the checklist the last item:

You can also set in which cases to stop the flow: always, or only when the breakpoint has been fetched determined times:

After you have set the breakpoints, debug the application and, when the breakpoint has been hit, open the "Locals" window. In this window you will find all variables in scope:

That's all. We hope that this example will be useful to you.

Happy programming.....

      by Carmel Schvartzman

כתב: כרמל שוורצמן