2.7.1.6 DMQueryTaskDataObjectDataType

  • Article

The DMQueryTaskDataObjectDataType type is used to specify parameters, properties, and settings that are specific to the Data Mining Query Task.

The following is the XSD for the DMQueryTaskDataObjectDataType type.

   <xs:complexType name="DMQueryTaskDataObjectDataType">
     <xs:sequence>
       <xs:element name="QueryString" form="unqualified"
                   type="DTS:DMQueryTaskQueryStringContainerType"/>
       <xs:element name="QueryBuilderQueryString" form="unqualified"
                   type="DTS:DMQueryTaskQueryStringContainerType"/>
       <xs:element name="QueryBuilderSpecification" form="unqualified"
                   type="DTS:DMQueryBuilderSpecificationType"/>
     </xs:sequence>
     <xs:attribute name="InputConnection" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="OutputConnection" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="ModelStructureName" type="xs:string"
                   form="unqualified"/>
     <xs:attribute name="ModelName" type="xs:string" form="unqualified"/>
     <xs:attribute name="OverwriteOutputTable" form="unqualified">
       <xs:simpleType>
         <xs:restriction base="xs:string">
           <xs:enumeration value="True"/>
           <xs:enumeration value="False"/>
         </xs:restriction>
       </xs:simpleType>
     </xs:attribute>
     <xs:attribute name="OutputTableName" type="xs:string"
                   form="unqualified"/>
   </xs:complexType>

The following table specifies the elements of the DMQueryTaskDataObjectDataType type.

Element

Type definition

Description

QueryString

DMQueryTaskQueryStringContainerType

A string that specifies a data mining query.<61>

QueryBuilderQueryString

DMQueryTaskQueryStringContainerType

A string that specifies a data mining query that appears in the UI for data mining as the initial query string, which the user can then modify.

QueryBuilderSpecification

DMQueryBuilderSpecificationType

The complex content contained in the QueryBuilderSpecification element specifies information about the state of the Microsoft SQL Server Integration Services (SSIS) UI between sessions so that editing sessions can start from where a previous session finished. Further description of the contents of this element is outside the scope of this document.

The following table specifies the attributes of the DMQueryTaskDataObjectDataType type.

Attribute

Description

InputConnection

This string value is the connection string to the data source for the data mining operation.

OutputConnection

This string value is the connection string to the database where the results of the data mining operation are written.

ModelStructureName

This string value contains the name of the data mining structure [MSDN-MSASDM] that is used for the data mining operation.

ModelName

This string value contains the name of the data mining model [MSDN-MMASDM] that is used for the data mining operation.

OverwriteOutputTable

This enumeration value specifies whether the table that is specified in the OutputTableName attribute can be overwritten.

"True" specifies that data in the output table can be overwritten.

"False" specifies that data in the output table cannot be overwritten.

OutputTableName

The name of the table in the output database where the results of the data mining operation are written.