Partilhar via


Interface IDtsDesignerUtilitiesService

Provides methods that let Integration Services developers invoke the Expression Builder dialog box programmatically.

Namespace:  Microsoft.SqlServer.Dts.Design
Assembly:  Microsoft.SqlServer.Dts.Design (em Microsoft.SqlServer.Dts.Design.dll)

Sintaxe

'Declaração
Public Interface IDtsDesignerUtilitiesService
'Uso
Dim instance As IDtsDesignerUtilitiesService
public interface IDtsDesignerUtilitiesService
public interface class IDtsDesignerUtilitiesService
type IDtsDesignerUtilitiesService =  interface end
public interface IDtsDesignerUtilitiesService

O tipo IDtsDesignerUtilitiesService expõe os membros a seguir.

Métodos

  Nome Descrição
Método público EditExpression Displays the Expression Builder dialog box that lets the end user use the Integration Services expression language to create and test an expression.
Método público EditPropertyExpression Displays the Expression Builder dialog box that lets the end user use the Integration Services expression language to create and test a property expression.

Início

Comentários

The IDtsDesignerUtilitiesService interface provides two methods, EditExpression and EditPropertyExpression, that let you invoke the Expression Builder dialog box programmatically. You might incorporate these methods into a custom user interface for an Integration Services connection manager, foreach enumerator, task, or data flow component.

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.

Exemplos

The following example shows how to cache a reference to a ServiceProvider whose type is IDtsDesignerUtilitiesService.

Dim designerUtilitiesService As IDtsDesignerUtilitiesService
designerUtilitiesService = _
      DirectCast(_serviceProvider.GetService(GetType(IDtsDesignerUtilitiesService)), IDtsDesignerUtilitiesService)
IDtsDesignerUtilitiesService designerUtilitiesService;
designerUtilitiesService = (IDtsDesignerUtilitiesService)_serviceProvider.GetService(typeof(IDtsDesignerUtilitiesService));

Consulte também

Referência

Namespace Microsoft.SqlServer.Dts.Design