SSIS, I would like to perform/validate an experssion in design mode. In particular, i would like to see the value of the varibles before running the whole package. I tried several time in Command Windows or Immedite Window unsuccessfully. Do those windows can only be used in running mode? Or how can I do that in other way?
Thanks
Where are you performing the expression? In the Control Flow or Data Flow.
This BOL entry describes how to evaluate an expression at design time in the Control Flow: http://msdn2.microsoft.com/en-us/library/ms141698.aspx
Expressions in the data flow are validated automatically at design time and any errors will be raised - but they can not be evaluated at design time.
Debug windows are only available when the package is running in the debugger.
Donald Farmer
|||That's mean I must create varibles in Control flow or date flow even though i just want to see the result of 1+1? Can't it like in VB or C# IDE?
|||
I'm still not clear where you are using the expression, so it's difficult to help in detail. You can evaluate Property Expressions, but not expressions in the data flow.
Donald
No comments:
Post a Comment