2.7.1.1.1.1.4.1.1 PipelineComponentOutputColumnsType

The PipelineComponentOutputColumnsType type specifies a collection of column objects for an output element that is part of a Pipeline component.

The following is the XSD for the PipelineComponentOutputColumnsType type.

   <xs:complexType name="PipelineComponentOutputColumnsType">
     <xs:sequence>
       <xs:element name="outputColumn" 
                   type="DTS:PipelineComponentOutputColumnType" 
            minOccurs="0" maxOccurs="unbounded" form="unqualified"/>
     </xs:sequence>
   </xs:complexType>

The following table specifies the elements of the PipelineComponentOutputColumnsType type.

Element

Type definition

Description

outputColumn

PipelineComponentOutputColumnType

A complex type that specifies a single column within a collection of output columns for a Pipeline component.

2.7.1.1.1.1.4.1.1.1   PipelineComponentOutputColumnType

The PipelineComponentOutputColumnType type specifies a single column that is a member of a collection of output columns in a Pipeline component.

The following is the XSD for the PipelineComponentOutputColumnType type.

   <xs:complexType name="PipelineComponentOutputColumnType">
     <xs:sequence>
       <xs:element name="properties"
                   type="DTS:PipelineComponentOutputColumnPropertiesType"
                   form="unqualified" minOccurs="0" maxOccurs="unbounded"/>
     </xs:sequence>
     <xs:attributeGroup
       ref="DTS:PipelineComponentAllColumnBaseAttributeGroup"/>
     <xs:attributeGroup
       ref="DTS:PipelineComponentIOColumnBaseAttributeGroup"/>
     <xs:attributeGroup
       ref="DTS:PipelineComponentColumnExtendedAttributeGroup"/>
     <xs:attribute name="sortKeyPosition" type="xs:int"
                   form="unqualified"/>
     <xs:attribute name="comparisonFlags" type="xs:int"
                   form="unqualified"/>
     <xs:attribute name="specialFlags" form="unqualified">
       <xs:simpleType>
         <xs:restriction base="xs:int">
           <xs:minInclusive value="0"/>
           <xs:maxInclusive value="2"/>
         </xs:restriction>
       </xs:simpleType>
     </xs:attribute>
   </xs:complexType>

The following table specifies the elements of the PipelineComponentOutputColumnType type.

Element

Type definition

Description

properties

PipelineComponentPropertiesType

A complex type that specifies a collection of properties for an output column.

The following table specifies the attributes and attribute groups of the PipelineComponentOutputColumnType type.

Attribute group or attribute

Description

PipelineComponentAllColumnBaseAttributeGroup

An attribute group specification that specifies attributes that are common to all types of columns for Pipeline components.

PipelineComponentIOColumnBaseAttributeGroup

An attribute group specification that specifies attributes that are common to all input and output columns for Pipeline components.

PipelineComponentColumnExtendedAttributeGroup

An attribute group specification that specifies additional attributes present for the PipelineComponentOutputColumnType type.

sortKeyPosition

An integer value that specifies the position of this column among the sort keys.

comparisonFlags

An integer value that is a bitmask that specifies which options are chosen for comparison of values in the column. The interpretation of the bits in this integer is as follows:

0x00000001 – Ignore case.

0x00000002 – Ignore nonspace characters.

0x00000004 – Ignore symbols.

0x00000010 – Linguistically appropriate ignore case.

0x00000020 – Linguistically appropriate ignore nonspace characters.

0x00010000 – Ignore Kana type.

0x00020000 - Ignore width.

0x08000000 – Use linguistic rules for casing.

specialFlags

An integer enumeration value that specifies whether the column contains special information. The allowed values are the following:

0 – No special information is contained in the column.

1 – The data in the column contains error codes.

2 – The data in the column contains the lineage identifier of the column in which an error occurred.

2.7.1.1.1.1.4.1.1.2   PipelineComponentOutputColumnPropertiesType

The PipelineComponentOutputColumnPropertiesType type specifies a collection of properties for an outputColumn element that is part of a Pipeline component.

The following is the XSD for the PipelineComponentOutputColumnPropertiesType type.

   <xs:complexType name="PipelineComponentOutputColumnPropertiesType">
     <xs:sequence>
       <xs:element name="property" form="unqualified"
                   type="DTS:PipelineComponentOutputColumnPropertyType"
                   minOccurs="0" maxOccurs="unbounded"/>
     </xs:sequence>
   </xs:complexType>

The following table specifies the elements of the PipelineComponentOutputColumnPropertiesType type.

Element

Type definition

Description

property

PipelineComponentOutputColumnPropertyType

A complex type that specifies a single property within a collection of input column properties for an outputColumn element of a Pipeline component.

2.7.1.1.1.1.4.1.1.2.1   PipelineComponentOutputColumnPropertyType

The PipelineComponentOutputColumnPropertyType type specifies a property for an outputColumn element.

The following is the XSD for the PipelineComponentOutputColumnPropertyType type.

   <xs:complexType name="PipelineComponentOutputColumnPropertyType">
     <xs:simpleContent>
       <xs:extension base="xs:anySimpleType">
         <xs:attributeGroup
           ref="DTS:PipelineComponentPropertyAttributeGroup"/>
         <xs:attribute name="name" form="unqualified"
             type="DTS:PipelineComponentOutputColumnPropertyNameEnum"/>
       </xs:extension>
     </xs:simpleContent>
   </xs:complexType>

The following table specifies the attributes and attribute groups of the PipelineComponentOutputColumnPropertyType type.

Attribute group

Description

PipelineComponentPropertyAttributeGroup

An attribute group that contains attributes that are common to all property elements for input elements, output elements, inputColumn elements, and outputColumn elements.

name

An enumeration value that specifies the name of the property.

2.7.1.1.1.1.4.1.1.2.1.1   PipelineComponentOutputColumnPropertyNameEnum

The PipelineComponentOutputColumnPropertyNameEnum type contains the allowed values for the name attribute on the outputColumn element of a Pipeline component. The allowed values for the property element for each task are more restricted than the values that are specified formally by the XSD.

Each name attribute value MUST NOT be used for any component except for the components that are specified in the subsections to this section. Some components allow no properties.

The additional restrictions specified in the subsections to this section MUST be followed for the name attribute on the property element children of the outputColumn element.

   <xs:simpleType name="PipelineComponentOutputColumnPropertyNameEnum">
     <xs:restriction base="xs:string">
       <!--Transforms-->
       <!--Aggregate Task-->
       <xs:enumeration value="AggregationColumnId"/>
       <xs:enumeration value="AggregationType"/>
       <xs:enumeration value="IsBig"/>
       <xs:enumeration value="AggregationComparisonFlags"/>
       <xs:enumeration value="CountDistinctKey"/>
       <xs:enumeration value="CountDistinctScale"/>
       <!--Audit-->
       <xs:enumeration value="LineageItemSelected"/>
       <!--Cache Transform (none)-->
       <!--Character Map (none)-->
       <!--Conditional Split (none)-->
       <!--Copy Column (none)-->
       <xs:enumeration value="copyColumnId"/>
       <!--Data Conversion (none)-->
       <xs:enumeration value="SourceInputColumnLineageID"/>
       <xs:enumeration value="FastParse"/>
       <!--Data Mining Query-->
       <!--Derived Column Query (none)-->
       <xs:enumeration value="Expression"/>
       <xs:enumeration value="FriendlyExpression"/>
       <!--Export Column Query (none)-->
       <!--Fuzzy Grouping-->
       <xs:enumeration value="ColumnType"/>
       <xs:enumeration value="InputId"/>
       <!--Fuzzy Lookup-->
       <xs:enumeration value="CopyFromReferenceColumn"/>
       <xs:enumeration value="SourceInputColumnLineageID"/>
       <xs:enumeration value="ColumnType"/>
       <!--Import Column (none)-->
       <!--Lookup-->
       <xs:enumeration value="CopyFromReferenceColumn"/>
       <!--Merge (none)-->
       <!--MergeJoin-->
       <xs:enumeration value="InputColumnID"/>
       <!--Multicast (none)-->
       <!--OLE DB Command (none)-->
       <!--Percentage Sampling (none)-->
       <!--Pivot-->
       <xs:enumeration value="SourceColumn"/>
       <xs:enumeration value="PivotKeyValue"/>
       <!--RowCount (none)-->
       <!--Row Sampling-->
       <xs:enumeration value="InputColumnLineageID"/>
       <!--Script Component (none)-->
       <!--Slowly Changing Dimension (none)-->
       <!--Sort-->
       <xs:enumeration value="SortColumnId"/>
       <!--Term Extraction(none)-->
       <!--Term Lookup-->
       <xs:enumeration value="CustomLineageID"/>
       <!--UnionAll (none)-->
       <!--Unpivot (none)-->
       <xs:enumeration value="PivotKey"/>
       <!--Data Sources-->
       <!--ADO.Net Source(none)-->
       <!--Excel Source(none)-->
       <!--Flat File Source-->
       <xs:enumeration value="FastParse"/>
       <xs:enumeration value="UseBinaryFormat"/>
       <!--OLEDB Source Task(none)-->
       <!--Raw File Source(none)-->
       <!--XML Source(none)-->
     </xs:restriction>
   </xs:simpleType>

2.7.1.1.1.1.4.1.1.2.1.1.1   Aggregate Component outputColumn Element

The Aggregate Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the name attribute values that are allowed for the Aggregate Component Task on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

AggregationColumnId

An integer value that specifies the lineage identifier of a column that participates in a Group By or an aggregation operation.

AggregationType

An integer value that specifies the type of aggregation to be performed. The enumeration values are interpreted as follows:

0 – Group by.

1 – Count.

2 – Count all.

3 – Count distinct.

4 – Sum.

5 – Average.

6 – Minimum.

7 – Maximum.

IsBig

A Boolean value that specifies whether the column has a very large value (greater than 4 billion) or a very precise value (more precision than double precision).

TRUE specifies that the column contains a very large or very precise value.

FALSE specifies that the column does not contain a very large or very precise value.

AggregationComparisonFlags

An integer value that is a bitmask that specifies the comparison flags for the sort operation. The bit values are as follows:

0x00000001 - Ignore case.

0x00000002 - Ignore nonspace characters.

0x00001000 - Ignore Kana type.

0x00002000 - Ignore character width.

CountDistinctScale

An integer value that specifies the approximate number of groups that is expected by the operation. This value is used to optimize computation. The enumeration values are interpreted as follows:

0 – The key scale is not used.

1 – Aggregation writes 0 to 500,000 keys.

2 – Aggregation writes 500,000 to 25,000,000 keys.

3– Aggregation writes more than 25,000,000 keys.

CountDistinctKeys

An integer value that specifies the exact number of Group By keys that can be written. If this value is specified, it takes precedence over the value of the CountDistinctScale attribute.

2.7.1.1.1.1.4.1.1.2.1.1.2   Audit Component outputColumn Element

The Audit Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Audit Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

LineageItemSelected

An integer value that specifies the audit item that is selected for output. The allowed values are as follows:

0 – Execution Instance GUID.

1 – Package ID.

2 – Package Name.

3 – Version ID.

4 - Execution Start Time.

5 - Machine Name.

6 - User Name.

7 - Task Name.

8 - Task ID.

2.7.1.1.1.1.4.1.1.2.1.1.3   Cache Transform Component outputColumn Element

The Cache Transform Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.4   Character Map Component outputColumn Element

The Character Map Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.5   Conditional Split Component outputColumn Element

The Conditional Split Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.6   Copy Column Component outputColumn Element

The Copy Column Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Copy Column Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

copyColumnId

An integer value that specifies the lineage identifier of the column to copy.

2.7.1.1.1.1.4.1.1.2.1.1.7   Data Conversion Component outputColumn Element

The Data Conversion Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Data Conversion Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

SourceInputColumnLineageId

An integer value that specifies the lineage identifier of the source input column.

FastParse

A Boolean value that specifies whether to use the locale-neutral fast parse algorithm.

TRUE specifies to use the fast parse algorithm.

FALSE specifies not to use the fast parse algorithm.

2.7.1.1.1.1.4.1.1.2.1.1.8   Data Mining Query Component outputColumn Element

The Data Mining Query Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.9   Derived Column Component outputColumn Element

The Derived Column Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Derived Column Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

Expression

A string value that specifies the expression by which the column is derived.

FriendlyExpression

A Boolean value that specifies whether to use the locale-neutral fast parse algorithm.

TRUE specifies to use the fast parse algorithm.

FALSE specifies not to use the fast parse algorithm.

2.7.1.1.1.1.4.1.1.2.1.1.10   Export Column Component outputColumn Element

The Export Column Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.11   Fuzzy Grouping Component outputColumn Element

The Fuzzy Grouping Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Fuzzy Grouping Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

ColumnType

An integer value that specifies the type of the column. The allowed values are as follows:

0 – The type of the column is undefined.

1 – The column is a key input.

2 – The column is a key output.

3 – The column contains the similarity value.

4 – The column contains the column similarity value.

5 – The column is passthrough.

6 – The column is canonical.

InputId

An integer value that specifies the lineage identifier of the corresponding input column.

2.7.1.1.1.1.4.1.1.2.1.1.12   Fuzzy Lookup Component outputColumn Element

The Fuzzy Lookup Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Fuzzy Lookup Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

CopyFromReferenceColumn

A string value that specifies the name of the column in the reference table that provides the values for this output column.

SourceInputColumnLineageID

An integer value that specifies the lineage identifier of the source input column.

ColumnType

An integer value that specifies the type of the column. The allowed values are as follows:

0 – The type of the column is undefined.

1 – The column contains the similarity value.

2 – The column contains the confidence value.

3 – The column contains the column similarity value.

InputId

An integer value that specifies the lineage identifier of the corresponding input column.

2.7.1.1.1.1.4.1.1.2.1.1.13   Import Column Component outputColumn Element

The Import Column Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.14   Lookup Component outputColumn Element

The Lookup Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Lookup Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

CopyFromReferenceColumn

A string value that specifies the name of the column in the reference table that provides the values for this output column.

2.7.1.1.1.1.4.1.1.2.1.1.15   Merge Component outputColumn Element

The Merge Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Merge Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

OutputColumnLineageID

A string value that specifies the lineage identifier of the output column.

2.7.1.1.1.1.4.1.1.2.1.1.16   MergeJoin Component outputColumn Element

The MergeJoin Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for MergeJoin Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

InputColumnID

A string value that specifies the lineage identifier of the input column from which data is copied to this output column.

2.7.1.1.1.1.4.1.1.2.1.1.17   Multicast Component outputColumn Element

The Multicast Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.18   OLE DB Command Component outputColumn Element

The OLE DB Command Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.19   Percentage Sampling Component outputColumn Element

The Percentage Sampling Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.20   Pivot Component outputColumn Element

The Pivot Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for the Pivot Component Task on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

SourceColumn

An integer value that specifies the lineage identifier of the input column that contains a pivoted value.<52>

PivotKeyValue

A string value that specifies one of the possible set of pivot keys that are identified in the input.

2.7.1.1.1.1.4.1.1.2.1.1.21   RowCount Component outputColumn Element

The RowCount Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.22   Row Sampling Component outputColumn Element

The Row Sampling Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Row Sampling Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

InputColumnLineageID

An integer value that specifies the lineage identifier of the input column that is the source of this output column.

2.7.1.1.1.1.4.1.1.2.1.1.23   Script Component outputColumn Element

The Script Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.24   Slowly Changing Dimension Component outputColumn Element

The Slowly Changing Dimension Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.25   Sort Component outputColumn Element

The Sort Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Sort Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

SortColumnID

An integer value that specifies the lineage identifier of the sort column.

2.7.1.1.1.1.4.1.1.2.1.1.26   Term Extraction Component outputColumn Element

The Term Extraction Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.27   Term Lookup Component outputColumn Element

The Term Lookup Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Term Lookup Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

CustomLineageID

An integer value that specifies the lineage identifier of the corresponding input column.

2.7.1.1.1.1.4.1.1.2.1.1.28   Union All Component outputColumn Element

The Union All Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.29   Unpivot Component outputColumn Element

The Unpivot Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Unpivot Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

PivotKey

A Boolean value that specifies whether the PivotKeyValue property of input columns is written to this output column.

TRUE specifies that the PivotKeyValue property of input columns is written to this output column.

FALSE specifies that the PivotKeyValue property of input columns is not written to this output column.

2.7.1.1.1.1.4.1.1.2.1.1.30   ADO.NET Source Component outputColumn Element

The ADO.NET Source Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.31   Excel Source Component outputColumn Element

The Excel Source Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.32   Flat File Source Component outputColumn Element

The Flat File Source Component outputColumn element MUST NOT use any Name attribute value on a property element except for those that are listed in the table in this section.

The following table specifies the Name attribute values that are allowed for Flat File Source Component on the outputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.

Name attribute value

Description

FastParse

A Boolean value that specifies whether the component uses the faster, locale-insensitive parsing method.

TRUE specifies that the faster, locale-insensitive parsing method is used.

FALSE specifies that the faster, locale-insensitive parsing method is not used.

UseBinaryFormat

A Boolean value that specifies whether data from the source is in binary format.

TRUE specifies that the data is in binary format.

FALSE specifies that the data is not in binary format.

2.7.1.1.1.1.4.1.1.2.1.1.33   OLE DB Source Component outputColumn Element

The OLE DB Source Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.34   Raw File Source Component outputColumn Element

The Raw File Source Component MUST NOT have any properties on the outputColumn element.

2.7.1.1.1.1.4.1.1.2.1.1.35   XML Source Component outputColumn Element

The XML Source Component MUST NOT have any properties on the outputColumn element.