Export (0) Print
Expand All

ResultParameter Class

Binds the DMX query result to an SSIS package variable. At run time, the DMX query result will be assigned to the SSIS package variable.

Object
  Microsoft.SqlServer.Dts.Tasks.DMQueryTask.ResultParameter

Namespace:  Microsoft.SqlServer.Dts.Tasks.DMQueryTask
Assembly:  Microsoft.SqlServer.DMQueryTask (in Microsoft.SqlServer.DMQueryTask.dll)

public class ResultParameter

The ResultParameter type exposes the following members.

  NameDescription
Public methodResultParameterInitializes a new instance of the ResultParameter class.
Top

  NameDescription
Public propertyDtsVariableNameGets or sets the name of the SSIS package variable.
Public propertyResultNameGets or sets the name of the ResultParameter.
Public propertyResultTypeGets or sets a value from the ParameterResultType enumeration, indicating whether the SSIS package variable should be populated with the column value matching the ResultName in the first row of the DMX query result, or whether the variable should be populated with the entire DMX query result in the form of a DataTable.
Top

  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top

  NameDescription
Protected fieldm_dtsVariableNameInfrastructure. Specifies the name of the SSIS package variable.
Protected fieldm_resultNameInfrastructure. Specifies the name of the result.
Protected fieldm_resultTypeInfrastructure. Specifies the type of the result.
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft