2.8.3 LoggingOptionsType

The LoggingOptionsType complex type contains information about how logging and filtering of logging information is performed in the containing executable.

The following is the XSD of the LoggingOptionsType complex type.

   <xs:complexType name="LoggingOptionsType">
     <xs:sequence>
       <xs:element name="Property" 
                   type="DTS:LoggingOptionsPropertyElementType"
                   maxOccurs="unbounded">
       </xs:element>
       <xs:element name="PropertyExpression"
                   type="DTS:PropertyExpressionElementType"
                   minOccurs="0" maxOccurs="unbounded"/>
       <xs:element name="SelectedLogProvider" minOccurs="0"
           maxOccurs="unbounded" type="DTS:SelectedLogProviderType"/>
     </xs:sequence>
   </xs:complexType>

As the XSD shows, the Property element of the LoggingOptionsType complex type uses a different base type than the Property element does for most other objects in the DTSX structure.

The following table provides additional information about the elements, types, and constraints for the LoggingOptionsType complex type.

Element

Additional 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. If the Name attribute of the Property is not equal to "ColumnFilter", the Property element MUST NOT have child elements. If the Name attribute equals "ColumnFilter", the Property element is a complex type. For more information, see Property Name=ColumnFilter.

Inline in the XSD in this section.

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

PropertyExpression

Additional constraints exist for the PropertyExpression element. These constraints MUST be followed. For a description of the constraints, see PropertyExpressionElementType.

PropertyExpressionElementType

The PropertyExpression element 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 that is stored in the Microsoft SQL Server Integration Services (SSIS) file format.

SelectedLogProvider

None.

SelectedLogProviderType

Contains a reference to the log provider that is to be used.