IDtsDesignerUtilitiesService.EditExpression Method
Displays the Expression Builder dialog box that lets the end user use the Integration Services expression language to create and test an expression.
Namespace: Microsoft.SqlServer.Dts.Design
Assembly: Microsoft.SqlServer.Dts.Design (in Microsoft.SqlServer.Dts.Design.dll)
Syntax
'Declaration
Function EditExpression ( _
parentWindow As IWin32Window, _
dtsContainer As DtsContainer, _
expressionType As Type, _
ByRef expression As String _
) As Boolean
'Usage
Dim instance As IDtsDesignerUtilitiesService
Dim parentWindow As IWin32Window
Dim dtsContainer As DtsContainer
Dim expressionType As Type
Dim expression As String
Dim returnValue As Boolean
returnValue = instance.EditExpression(parentWindow, _
dtsContainer, expressionType, expression)
bool EditExpression(
IWin32Window parentWindow,
DtsContainer dtsContainer,
Type expressionType,
ref string expression
)
bool EditExpression(
IWin32Window^ parentWindow,
DtsContainer^ dtsContainer,
Type^ expressionType,
String^% expression
)
abstract EditExpression :
parentWindow:IWin32Window *
dtsContainer:DtsContainer *
expressionType:Type *
expression:string byref -> bool
function EditExpression(
parentWindow : IWin32Window,
dtsContainer : DtsContainer,
expressionType : Type,
expression : String
) : boolean
Parameters
- parentWindow
Type: System.Windows.Forms.IWin32Window
The IWin32Window handle to the Windows form from which the Expression Builder dialog box is invoked.
- dtsContainer
Type: Microsoft.SqlServer.Dts.Runtime.DtsContainer
The DtsContainer that defines the scope for package variables that can be used in the expression.
- expressionType
Type: System.Type
The Type of the return type of the expression.
- expression
Type: System.String%
A string that is passed by reference and represents the expression.
Return Value
Type: System.Boolean
true if the expression has changed; otherwise, false.
Remarks
You can use the EditExpression method whenever you want to let the user create or modify an expression. However, to modify a property expression, the EditPropertyExpression method might be more useful. The EditPropertyExpression method determines the return type of the expression from the data type of the property and assigns the expression to the property for you.