July 13, 2011 at 9:21 am
How do i debug a Script task...I need to know the values in the variables...Is it possible to step through???
July 13, 2011 at 9:31 am
Of course. Set breakpoints and run interactively in BIDS.
Debugging a Script Component is not so easy ...
July 13, 2011 at 9:33 am
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..
CEWII
July 13, 2011 at 9:49 am
Elliott Whitlow (7/13/2011)
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..CEWII
You do not remember correctly - it works in SSIS 2005:-)
But there was a bug (I think) - if you've got multiple script tasks chained together and you're trying to debug one of the later scripts, breakpoints are sometimes just ignored. I can't remember the exact circumstances.
July 13, 2011 at 10:36 am
Phil Parkin (7/13/2011)
Elliott Whitlow (7/13/2011)
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..CEWII
You do not remember correctly - it works in SSIS 2005:-)
But there was a bug (I think) - if you've got multiple script tasks chained together and you're trying to debug one of the later scripts, breakpoints are sometimes just ignored. I can't remember the exact circumstances.
Then I stand corrected, its been a while for me with SSIS 2005. I have spent significantly more time with SSIS 2008 and a wee bit with 2011.
CEWII
July 13, 2011 at 11:02 am
BIDS 2005 requires you to run the entire package to be able to debug using breakpoints on a script task. If you try to just execute the script task by itself, the breakpoints are ignored.
July 14, 2011 at 2:29 am
Phil Parkin (7/13/2011)
Of course. Set breakpoints and run interactively in BIDS.Debugging a Script Component is not so easy ...
To expand: take a look at the Locals window and the Watch window (if you added a watch to a variable).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy