March 19, 2012 at 12:32 pm
I have a SSIS package with an execute SQL Task where I have a variable that should pass a MAX ID number through to a data flow.
I want to see the variable value on debug. I have set up a breakpoint on the Execute SQL task but there is nothing shown in the Locals window on the debug.
Any advise would be greatly appreciated.
March 19, 2012 at 2:34 pm
Maybe you should set the breakpoint on the pre-execute of the data flow - it may be that your breakpoint is being hit before the variable's value has been set.
If this is not the case, please attach a screen shot to illustrate exactly what you are seeing.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 19, 2012 at 2:41 pm
Phil thank you for your reply. But after a long search I finally realised what was occuring (which I must say is poorly documented) however I found the answer on a forum here.
Instead of hitting the debug triangle I was right clicking and executing the task which will not show the debug windows.
After fiddling around with packaging configurations all goiing according to plan now.
Thanks again.:-)
March 19, 2012 at 2:49 pm
Aha, I should have thought about that.
Well done on figuring it out.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 31, 2016 at 3:11 am
if set sensitive of any variable to on
all the local variables will beccome invisible
November 9, 2016 at 6:38 am
Larry-443745 (5/31/2016)
if set sensitive of any variable to onall the local variables will beccome invisible
Thanks Larry-443745 I have just spent ages trying to figure that one out.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply