Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tmitch
Yak Posting Veteran
60 Posts |
 Posted - 2007-11-14 : 16:58:58
|
| Is there a quick and easy way, other than scripting a MsgBox(), to show the value of a package variable while the package is running? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 09:24:55
|
| There is this tool called data viewer. Right click on flow arrow to add it.If your variable is in the data, which typically is the case, then you can see it coming through that way. |
 |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2007-11-15 : 15:27:23
|
| Thanks, but the variable is not in the data flow - it actually serves as part of the control flow. I've found some references in SSIS docs to the Immediate Window, a tool in Visual Studio that can be used in debugging .NET apps. However, the Immediate window does not appear to be available when running VS in BIDS mode. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 15:39:31
|
| You could also set a break point in an event handler to show you the value of the variable. |
|
|
|
|
|
|
Show variable values at runtime