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.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Dts.Tasks.DMQueryTask.ResultParameter
Namespace: Microsoft.SqlServer.Dts.Tasks.DMQueryTask
Assembly: Microsoft.SqlServer.DMQueryTask (in Microsoft.SqlServer.DMQueryTask.dll)
Syntax
'Declaration
Public Class ResultParameter
'Usage
Dim instance As ResultParameter
public class ResultParameter
public ref class ResultParameter
type ResultParameter = class end
public class ResultParameter
The ResultParameter type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
ResultParameter | Initializes a new instance of the ResultParameter class. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
DtsVariableName | Gets or sets the name of the SSIS package variable. |
|
ResultName | Gets or sets the name of the ResultParameter. |
|
ResultType | Gets 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
Methods
| Name | Description | |
|---|---|---|
|
Equals | (Inherited from Object.) |
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
GetHashCode | (Inherited from Object.) |
|
GetType | (Inherited from Object.) |
|
MemberwiseClone | (Inherited from Object.) |
|
ToString | (Inherited from Object.) |
Top
Fields
| Name | Description | |
|---|---|---|
.gif "Protected field") |
m_dtsVariableName | Infrastructure. Specifies the name of the SSIS package variable. |
|
m_resultName | Infrastructure. Specifies the name of the result. |
|
m_resultType | Infrastructure. Specifies the type of the result. |
Top
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.