BIDS local window

This is a discussion on BIDS local window within the sqlserver-tools forums in Microsoft SQL Server category; I am developing a SSIS package using BIDS. I have many variable that are scope to the Package level. When I set breakpoints and go to the Locals window, there are no user defined variables only three system variables: ExecutionDuration, ExecutionStatus, and ExecutionResults. I also added a Watch window and it list one variable with the Name: Variables, Value: Unable to evaluate the expression. All the variables the have expressions setting evaluate with no problems. I am trying to set some variables with an ExecuteSQL task. Should all variables that are scoped at the Package level be listed in the ...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-tools

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-11-2008, 06:00 PM
Default BIDS local window

I am developing a SSIS package using BIDS. I have many variable that are
scope to the Package level. When I set breakpoints and go to the Locals
window, there are no user defined variables only three system variables:
ExecutionDuration, ExecutionStatus, and ExecutionResults. I also added a
Watch window and it list one variable with the Name: Variables, Value: Unable
to evaluate the expression. All the variables the have expressions setting
evaluate with no problems. I am trying to set some variables with an
ExecuteSQL task. Should all variables that are scoped at the Package level
be listed in the Locals window?

Fred
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 07:59 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.