2.6.3.2 ExecutableType Instance for AS Execute DDL Task

  • Article

Analysis Services (AS) Execute Data Definition Language (DDL) Task is a task that executes Analysis Services DDL language. AS DDL language is used to create, modify, and manage server objects on an Analysis Services server. An executable is an Analysis Services (AS) Execute Data Definition Language (DDL) Task executable if the ExecutableType attribute value is "Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask, Microsoft.SqlServer.ASTasks, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91".

The AS Execute DDL Task executable is formally defined to be of type AnyNonPackageExecutableType. However, the following XSD fragment, which is expressed as an anonymous complex type declaration, places further restrictions on the type than the restrictions that are declared in the AnyNonPackageExecutableType type declaration. An Executable element with the ExecutableType attribute value equal to "Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask, Microsoft.SqlServer.ASTasks, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" MUST follow the anonymous type declaration that is contained in this section.

Note the following differences between this anonymous complex type declaration and the full definition of the complex type for the AnyNonPackageExecutableType type:

  • This Executable element MUST NOT contain an Executable element.

  • This Executable element MUST NOT contain a ForEachEnumerator element.

  • This Executable element MUST NOT contain a ForEachVariableMapping element.

  • In the AnyNonPackageExecutableType type, the type of the ObjectData element is given as ExecutableObjectDataType. The ExecutableObjectDataType type definition contains an xs:choice XSD Schema element. However, not all of the choices that are allowed in the xs:choice XSD Schema element are available for the AS Execute DDL executable. For this Executable element, the ObjectData element MUST contain the ASDdlData element of type ASDdlDataObjectDataType.

  • The allowed values for the Name attribute of the Property element are a restricted subset of the values that are allowed on the type, as specified in the AnyNonPackageExecutablePropertyNameEnum type. Hence, the formal type declaration of the Property element and the PropertyExpression elements are replaced in this anonymous XSD fragment with a reference to the TaskExePropertyNameEnum simple type. The Name attribute of the Property element MUST be restricted to the values that are shown as valid in the XSD fragment contained in that section.

For more information about the elements, attributes, and enumeration values in the following XSD fragment, see section 2.5.

   <xs:complexType>
     <xs:sequence>
       <xs:element name="ForEachEnumerator"
                   type="DTS:ForEachEnumeratorType"
                   minOccurs="0" maxOccurs="0"/>
       <xs:element name="Property"
                   maxOccurs="unbounded">
         <xs:complexType>
           <xs:complexContent>
             <xs:extension base="DTS:PropertyElementBaseType">
               <xs:attribute name="Name"
                   type="DTS:TaskExePropertyNameEnum"
                   use="required"/>
             </xs:extension>
           </xs:complexContent>
         </xs:complexType>
       </xs:element>
       <xs:element name="Variable" type="DTS:VariableType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="LoggingOptions" type="DTS:LoggingOptionsType" />
       <xs:element name="PropertyExpression"
                   type="DTS:PropertyExpressionElementType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="PrecedenceConstraint"
                   type="DTS:PrecedenceConstraintType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="ForEachVariableMapping"
                   type="DTS:ForEachVariableMappingType"
                   minOccurs="0" maxOccurs="0"/>
       <xs:element name="EventHandler" type="DTS:EventHandlerType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="ObjectData">
         <xs:complexType>
           <xs:choice>
             <xs:element name="ASDdlData" type="DTS:ASDdlDataObjectDataType"/>
           </xs:choice>
         </xs:complexType>
       </xs:element>
     </xs:sequence>
     <xs:attribute name="ExecutableType" use="required">
       <xs:simpleType>
         <xs:restriction base="xs:string">
           <xs:enumeration value="Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask, Microsoft.SqlServer.ASTasks, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
         </xs:restriction>
       </xs:simpleType>
     </xs:attribute>
     <xs:attribute name="ThreadHint" use="optional" type="xs:int"/>
   </xs:complexType>