Tuesday, April 21, 2015

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



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" :
check SSIS Variables values at debugging runtime

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:

values at debugging runtime

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:


Variables values at debugging runtime


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:



SSIS Variables values at debugging runtime

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

How to check   values at debugging


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:

check SSIS Variables values at debugging runtime

How to check SSIS Variables values at debugging



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

Happy programming.....

      by Carmel Schvartzman


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