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.
The following tables list the members exposed by the ResultParameter type.
Public Constructors
| 名称 | Description | |
|---|---|---|
| ResultParameter | Initializes a new instance of the ResultParameter class. |
顶部
Protected Fields
| 名称 | Description | |
|---|---|---|
.gif "ms214662.protfield(zh-cn,SQL.90).gif") |
m_dtsVariableName | |
|
m_resultName | |
|
m_resultType |
顶部
Public Properties
| 名称 | Description | |
|---|---|---|
.gif "ms214662.pubproperty(zh-cn,SQL.90).gif") |
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 DMZ query result, or whether the variable should be populated with the entire DMX query result in the form of a DataTable. |
顶部
Public Methods
(see also Protected Methods )
| 名称 | Description | |
|---|---|---|
.gif "ms214662.pubmethod(zh-cn,SQL.90).gif") |
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
.gif "ms214662.static(zh-cn,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
ToString | (inherited from Object ) |
顶部
Protected Methods
| 名称 | Description | |
|---|---|---|
.gif "ms214662.protmethod(zh-cn,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
顶部
请参阅
参考
ResultParameter Class
Microsoft.SqlServer.Dts.Tasks.DMQueryTask Namespace