2.7.1.1.1.1.3.1.3 PipelineComponentInputColumnPropertiesType
The PipelineComponentInputColumnPropertiesType type specifies a collection of properties for an inputColumn element that is part of a Pipeline component.
The following is the XSD for the PipelineComponentInputColumnPropertiesType type.
-
<xs:complexType name="PipelineComponentInputColumnPropertiesType"> <xs:sequence> <xs:element name="property" form="unqualified" type="DTS:PipelineComponentInputColumnPropertyType" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType>
The following table specifies the elements of the PipelineComponentInputColumnPropertiesType type.
|
Element |
Type definition |
Description |
|---|---|---|
|
property |
PipelineComponentInputColumnPropertyType |
A complex type that specifies a single property within a collection of input column properties for an inputColumn element of a Pipeline component. |
2.7.1.1.1.1.3.1.3.1 PipelineComponentInputColumnPropertyType
The PipelineComponentInputColumnPropertyType type specifies a property of an inputColumn element.
The following is the XSD for the PipelineComponentInputColumnPropertyType type.
-
<xs:complexType name="PipelineComponentInputColumnPropertyType"> <xs:simpleContent> <xs:extension base="xs:anySimpleType"> <xs:attributeGroup ref="DTS:PipelineComponentPropertyAttributeGroup"/> <xs:attribute name="name" form="unqualified" type="DTS:PipelineComponentInputColumnPropertyNameEnum"/> </xs:extension> </xs:simpleContent> </xs:complexType>
The following table specifies the attributes and attribute groups of the PipelineComponentInputColumnPropertyType type.
|
Attribute |
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 |
A string value that specifies the name of the property |
2.7.1.1.1.1.3.1.3.1.1 PipelineComponentInputColumnPropertyNameEnum
The PipelineComponentInputColumnPropertyNameEnum type contains the allowed values for the name attribute on the inputColumn 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 inputColumn element.
The following is the XSD for the PipelineComponentInputColumnPropertyNameEnum type.
-
<xs:simpleType name="PipelineComponentInputColumnPropertyNameEnum"> <xs:restriction base="xs:string"> <!--Transforms--> <!--Aggregate Task--> <!--Audit (none)--> <!--Cache Transform--> <xs:enumeration value="CacheColumnName"/> <!--Character Map--> <xs:enumeration value="MapFlags"/> <!--Conditional Split (none)--> <!--Copy Column (none)--> <!--Data Conversion (none)--> <!--Data Mining Query(none)--> <!--Derived Column Query--> <xs:enumeration value="Expression"/> <xs:enumeration value="FriendlyExpression"/> <!--Export Column--> <xs:enumeration value="FileDataColumnID"/> <xs:enumeration value="WriteBOM"/> <xs:enumeration value="ForceTruncate"/> <xs:enumeration value="AllowAppend"/> <!--Fuzzy Grouping, Fuzzy Lookup--> <xs:enumeration value="ToBeCleaned"/> <xs:enumeration value="ExactFuzzy"/> <xs:enumeration value="LeadingTrailingNumeralsSignificant"/> <xs:enumeration value="MinSimilarity"/> <xs:enumeration value="FuzzyComparisonFlags"/> <!--Import Column--> <xs:enumeration value="FileDataColumnID"/> <xs:enumeration value="ExpectBOM"/> <!--Lookup--> <xs:enumeration value="JoinToReferenceColumn"/> <xs:enumeration value="CopyFromReferenceColumn"/> <!--Merge--> <xs:enumeration value="OutputColumnLineageID"/> <!--MergeJoin (none)--> <!--Multicast (none)--> <!--OLE DB Command (none)--> <!--Percentage Sampling (none)--> <!--Pivot--> <xs:enumeration value="PivotUsage"/> <!--RowCount(none)--> <!--Row Sampling(none)--> <!--Script Component(none)--> <!--Slowly Changing Dimension--> <xs:enumeration value="ColumnType"/> <!--Sort--> <xs:enumeration value="NewComparisonFlags"/> <xs:enumeration value="NewSortKeyPosition"/> <!--Term Extraction(none)--> <!--Term Lookup--> <xs:enumeration value="InputColumnType"/> <!--UnionAll--> <xs:enumeration value="OutputColumnLineageID"/> <!--Unpivot--> <xs:enumeration value="DestinationColumn"/> <xs:enumeration value="PivotKeyValue"/> <!--Data Destinations--> <!--ADO.Net Destination(none)--> <!--Excel Destination(none)--> <!--Flat File Destination(none)--> <!--OLE DB Destination(none)--> <!--Raw File Destination(none)--> <!--DataReader Destination(none)--> <!--Data Mining Model Training(none)--> <!--Dimension Processing(none)--> <!--Partition Processing(none)--> <!--RecordSet Destination(none)--> <!--SQL Server Compact Destination(none)--> <!--SQL Server Destination(none)--> </xs:restriction> </xs:simpleType>
2.7.1.1.1.1.3.1.3.1.1.1 Aggregate Component inputColumn Element
The Aggregate Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.2 Audit Component inputColumn Element
The Audit Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.3 Cache Transform Component inputColumn Element
The Cache Transform Component inputColumn 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 Cache Transform Component Task on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
CacheColumnName |
A string value that specifies the name of a column that is associated with an input column. |
2.7.1.1.1.1.3.1.3.1.1.4 Character Map Component inputColumn Element
The Character Map Component inputColumn 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 Character Map Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
MapFlags |
An integer value that specifies the string operation that is performed on the column. The allowed values are the following. 0 – Map to lower case. 1 – Map to upper case. 2 – Perform byte reversal. 3 – Map to Hiragana. 4 – Map to Katakana. 5 – Map to half width. 6 – Map to full width. 7 – Perform linguistic casing. 8 – Map to Simplified Chinese. 9 – Map to Traditional Chinese. |
2.7.1.1.1.1.3.1.3.1.1.5 Conditional Split Component inputColumn Element
The Conditional Split Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.6 Copy Column Component inputColumn Element
The Copy Column Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.7 Data Conversion Component inputColumn Element
The Data Conversion Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.8 Data Mining Query Component inputColumn Element
The Data Mining Query Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.9 Derived Column Component inputColumn Element
The Derived Column Component inputColumn 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 Derived Column Component on the inputColumn 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 string value that specifies a conditional expression by which the column is derived. The FriendlyExpression attribute uses column names in the expression syntax, while the Expression attribute uses only column lineage identifiers. |
2.7.1.1.1.1.3.1.3.1.1.10 Export Column Component inputColumn Element
The Export Column Component inputColumn 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 Export Column Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
FileDataColumnID |
An integer value that specifies the identifier for the column that contains the data that is inserted by the task. |
|
WriteBOM |
A Boolean value that specifies whether a byte order mark (BOM) is inserted into the file. TRUE specifies that a BOM is inserted into the file. FALSE specifies that a BOM is not inserted into the file. |
|
ForceTruncate |
A Boolean value that specifies whether a truncation is forced before a write operation on an existing file. TRUE specifies that a truncation is forced before a write operation on an existing file. FALSE specifies that a truncation is not forced before a write operation on an existing file. |
|
AllowAppend |
A Boolean value that specifies whether the transformation is allowed to append data to an existing file. TRUE specifies that the transformation is allowed to append data to an existing file. FALSE specifies that the transformation is not allowed to append data to an existing file. |
2.7.1.1.1.1.3.1.3.1.1.11 Fuzzy Grouping Component inputColumn Element
The Fuzzy Grouping Component inputColumn 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 Fuzzy Grouping Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
ToBeCleaned |
A Boolean value that specifies whether this is a column to be grouped by. TRUE specifies that this is a column to be grouped by. FALSE specifies that this is not a column to be grouped by. |
|
ExactFuzzy |
An integer value that specifies whether the fuzzy match is exact or fuzzy. The allowed values are the following: 1 – Exact. 2 – Fuzzy. |
|
LeadingTrailingNumeralsSignificant |
An integer value that specifies how to treat numerals. The allowed values are as follows: 0 – Numerals are not significant. 1 – Leading numerals are significant. 2 – Trailing numerals are significant. 3 – Both leading and trailing numerals are significant. |
|
MinSimilarity |
A double precision value between 0 and 1, inclusive, that specifies the similarity threshold to join on the column. Only rows that are greater than this value qualify as matches. |
|
FuzzyComparisonFlags |
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. 0x00000004 - Ignore symbols. 0x00000100 - Sort punctuation as symbols. 0x00001000 - Ignore Kana type. 0x00002000 - Ignore character width. |
2.7.1.1.1.1.3.1.3.1.1.12 Fuzzy Lookup Component inputColumn Element
The Fuzzy Lookup Component inputColumn 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 Fuzzy Lookup Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
ToBeCleaned |
A Boolean value that specifies whether this is a column to be grouped by. TRUE specifies that this is a column to be grouped by. FALSE specifies that this is not a column to be grouped by. |
|
ExactFuzzy |
An integer value that specifies whether the fuzzy match is exact or fuzzy. The allowed values are the following: 1 – Exact 2 – Fuzzy |
|
LeadingTrailingNumeralsSignificant |
An integer value that specifies how to treat numerals. The allowed values are as follows: 0 – Numerals are not significant. 1 – Leading numerals are significant. 2– Trailing numerals are significant. 3 – Both leading and trailing numerals are significant. |
|
MinSimilarity |
A double precision value between 0 and 1, inclusive, that specifies the similarity threshold to join on the column. Only rows that are greater than this value qualify as matches. |
|
FuzzyComparisonFlags |
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. 0x00000004 - Ignore symbols. 0x00000100 - Sort punctuation as symbols. 0x00001000 - Ignore Kana type. 0x00002000 - Ignore character width. |
2.7.1.1.1.1.3.1.3.1.1.13 Import Column Component inputColumn Element
The Import Column Component inputColumn 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 Import Column Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
FileDataColumnID |
An integer value that specifies the identifier for the column that contains the data that is inserted into the data flow. |
|
ExpectBOM |
A Boolean value that specifies whether a byte order mark (BOM) is expected in the column. TRUE specifies that a BOM is expected in the column. FALSE specifies that a BOM is not expected in the column. |
2.7.1.1.1.1.3.1.3.1.1.14 Lookup Component inputColumn Element
The Lookup Component inputColumn 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 Lookup Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
JoinToReferenceColumn |
A string value that specifies the name of the column in the reference table upon which to join. |
|
CopyFromReferenceColumn |
A string value that specifies the name of the column in the reference table from which a column is copied. |
2.7.1.1.1.1.3.1.3.1.1.15 Merge Component inputColumn Element
The Merge Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.16 MergeJoin Component inputColumn Element
The MergeJoin Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.17 Multicast Component inputColumn Element
The Multicast Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.18 OLE DB Command Component inputColumn Element
The OLE DB Command Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.19 Percentage Sampling Component inputColumn Element
The Percentage Sampling Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.20 Pivot Component inputColumn Element
The Pivot Component inputColumn 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 inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
PivotUsage |
An integer value that specifies the role of a column for pivoting. The allowed values are the following. 0 – The column is not pivoted. 1 – The column provides row keys. All input rows with the same value are combined into one output row. 2 – The column is a pivot column. At least one column is created for each value in this column. 3 – The values from this column are placed in one of the cells created by the pivot. |
2.7.1.1.1.1.3.1.3.1.1.21 RowCount Component inputColumn Element
The RowCount Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.22 Row Sampling Component inputColumn Element
The Row Sampling Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.23 Script Component inputColumn Element
The Script Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.24 Slowly Changing Dimension Component inputColumn Element
The Slowly Changing Dimension Component inputColumn 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 Slowly Changing Dimension Component Task on the inputColumn 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 update type for the column. 0 – Unknown. 1 – Key column. 2 – Changing attribute. 3 – Historical attribute. 4 – Fixed attribute. |
2.7.1.1.1.1.3.1.3.1.1.25 Sort Component inputColumn Element
The Sort Component inputColumn 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 Sort Component on the inputColumn element in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
NewComparisonFlags |
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. 0x00000004 - Ignore symbols. 0x00000100 - Sort punctuation as symbols. 0x00001000 - Ignore Kana type. 0x00002000 - Ignore character width. |
|
NewSortKeyPosition |
An integer value that specifies the sort order of the column. |
2.7.1.1.1.1.3.1.3.1.1.26 Term Extraction Component inputColumn Element
The Term Extraction Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.27 Term Lookup Component inputColumn Element
The Term Lookup Component inputColumn 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 Term Lookup Component Task on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
InputColumnType |
An integer value that specifies the input column type. The allowed values are the following: 0 – Passthrough column. 1 – Lookup column. 2 – Passthrough and lookup column. |
2.7.1.1.1.1.3.1.3.1.1.28 Union All Component inputColumn Element
The Union All Component inputColumn 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 Union All Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
OutputColumnLineageID |
An integer value that specifies the lineage identifier of the corresponding output column. |
2.7.1.1.1.1.3.1.3.1.1.29 Unpivot Component inputColumn Element
The Unpivot Component inputColumn 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 Unpivot Component on the inputColumn element, in addition to any restrictions on the element value. These restrictions MUST be followed.
|
Name attribute value |
Description |
|---|---|
|
DestinationColumn |
An integer value that specifies the lineage identifier of the corresponding output column.<51> |
|
PivotKeyValue |
A string value that specifies one of the pivot key values that is copied to an output column. |
2.7.1.1.1.1.3.1.3.1.1.30 ADO.NET Destination Component inputColumn Element
The ADO.NET Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.31 Excel Destination Component inputColumn Element
The Excel Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.32 Flat File Destination Component inputColumn Element
The Flat File Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.33 OLE DB Destination Component inputColumn Element
The OLE DB Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.34 DataReader Destination Component inputColumn Element
The DataReader Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.35 Data Mining Model Training Destination Component inputColumn Element
The Data Mining Model Training Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.36 Dimension Processing Destination Component inputColumn Element
The Dimension Processing Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.37 Partition Processing Destination Component inputColumn Element
The Partition Processing Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.38 Raw File Destination Component inputColumn Element
The Raw File Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.39 RecordSet Destination Component inputColumn Element
The RecordSet Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.40 SQL Server Compact Edition Destination Component inputColumn Element
The SQL Server Compact Edition Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.1.1.41 SQL Server Destination Component inputColumn Element
The SQL Server Destination Component MUST NOT have any properties on the inputColumn element.
2.7.1.1.1.1.3.1.3.2 PipelineComponentUsageTypeEnum
The PipelineComponentUsageTypeEnum type contains the enumeration values for the usageType attribute.
The following is the XSD for the PipelineComponentUsageTypeEnum type.
-
<xs:simpleType name="PipelineComponentUsageTypeEnum"> <xs:restriction base="xs:string"> <xs:enumeration value="readOnly"/> <xs:enumeration value="readWrite"/> <xs:enumeration value="Ignored"/> </xs:restriction> </xs:simpleType>
The following table specifies the enumeration values for the PipelineComponentUsageTypeEnum type.
|
Enumeration value |
Description |
|---|---|
|
readOnly |
The column is read-only. |
|
readWrite |
The column is available for read operations and for write operations. |
|
Ignored |
The column is ignored. |