Share via

2.4 ExecutableTypePackage

  • Article

The ExecutableTypePackage complex type defines the content of the Executable root element.

The following is the XSD definition for the ExecutableTypePackage complex type. 

   <xs:complexType name="ExecutableTypePackage">
     <xs:sequence>
       <xs:element name="Property" maxOccurs="unbounded">
         <xs:complexType>
           <xs:complexContent>
             <xs:extension base="DTS:PropertyElementBaseType">
               <xs:attribute name="Name"
                   type="DTS:ExecutableTypePackagePropertyNameEnum"
                   use="required"/>
             </xs:extension>
           </xs:complexContent>
         </xs:complexType>
       </xs:element>
       <xs:element name="ConnectionManager" type="DTS:ConnectionManagerType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="Configuration" type="DTS:ConfigurationType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="LogProvider" type="DTS:LogProviderType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <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="Executable" type="DTS:AnyNonPackageExecutableType"
                 minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="PrecedenceConstraint"
                   type="DTS:PrecedenceConstraintType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="EventHandler" type="DTS:EventHandlerType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="PackageVariable" type="DTS:PackageVariableType"
                   minOccurs="0" maxOccurs="unbounded"/>
     </xs:sequence>
     <xs:attribute name="ExecutableType" use="required"
               fixed="SSIS.Package.2" />
   </xs:complexType>

The following table provides additional information about the elements and types in the ExecutableTypePackage complex type. 

Element

Constraints

Type definition

Description

Property

In some cases, constraints are placed on the Property element's value for specific values of the Name attribute of the Property element. If such constraints exist, they are specified where the meaning of the particular property name is specified. These constraints MUST be followed. If the optional DataType attribute is present, the value of the Property element MUST be of the type indicated by the DataType attribute.

Inline in the XSD in this section.

Specifies values for many different properties associated with an instance of the containing Executable element, according to the Name attribute of each Property element.

ConnectionManager

None.

ConnectionManagerType

Specifies information about the data connections that are available to this package.

Configuration

None.

ConfigurationType

Specifies configuration information for the package.

LogProvider

None.

LogProviderType

Specifies the destination to which logging data is output.

Variable

None.

VariableType

Specifies definitions of variables that can be defined in the package.

LoggingOptions

None.

LoggingOptionsType

Specifies information about what kind of information is logged for this package and where it is recorded.

PropertyExpression

Additional constraints exist for the PropertyExpression element. For a description of these constraints, see PropertyExpressionElementType.

PropertyExpressionElementType

Serves the same purpose as specified for the Property element except that an expression that is evaluated at run time is contained in the element's value.

Executable

None.

AnyNonPackageExecutableType

Specifies the executables that are contained in this package

PrecedenceConstraint

None.

PrecedenceConstraintType

Specifies information about precedence constraints between contained executables in this package.

EventHandler

None.

EventHandlerType

Specifies event handlers for this package.

PackageVariable

None.

PackageVariableType

Specifies definitions of package variables for this package.

The following table provides additional information about the attributes and types in the ExecutableTypePackage complex type.

Attribute

Constraints

Description

ExecutableType

None.

Specifies information about the contents of the Executable element on which the attribute value appears.

The following table provides additional information about the attributes and types for the Property element that is declared inline in the complex type declaration. The Property element is an extension of the PropertyElementBaseType type with the addition of the Name attribute, which is specified in the following table.

Attribute

Constraints

Description

Name

None.

Specifies the Name of the Property element. Each named property has its own use and interpretation. The explanation for the interpretation of each named property is given with the definition of the type for the Name attribute.