December 17, 2009 at 7:48 pm
Is there a way to inspect task properties at runtime? Obviously, properties are visible in the property inspector, but that only displays the design time values. For instance, I have a Exec SQL task that has a query with a couple parameters. I'd just like to be able to "break" and inspect how the params were actually substituted into the Query. I don't see a way to do that.
The "Progress" window almost shows me what I'm looking for except it does not show very many chars of the SQL Statement. It truncates most of what I'm looking for.
.
December 17, 2009 at 9:06 pm
Right click on the task and add a Breakpoint on Pre Execute. While its executing you can see the variable values in the Locals tab that usually appears at the bottom of the environment. You can right click specific variables and add to Watch and they will appear in the less cluttered Watch window.
[font="Arial Narrow"]bc[/font]
December 18, 2009 at 10:02 am
[font="Comic Sans MS"]
As bc_ has already advised - you may like to see this video for detailed steps.
http://www.sqlservercentral.com/articles/Video/64762/
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
December 18, 2009 at 11:34 am
Thanks for the responses!
Like I said, I have no problem inspecting variables at runtime. I get it. What I'm looking for is a way to inspect package properties at runtime.
Again, I want to break on an Exec SQL task (which I know how to do), and inspect the task to see the exact SQL string that's about to be sent to the SQL Server. I need to see exactly how SSIS interpreted my query parameters.
Thanks for the help. BTW, I love those guys at JumpStart I usually watch one a day. Fantastic stuff.
.
December 18, 2009 at 12:25 pm
The only way I know would be to have the Execute SQL task use a Variable as the statement source. Then you could inspect that variable at runtime as explained previously.
[font="Arial Narrow"]bc[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply