Ole Db Command Parameter Element
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| SourceColumn | String | This value specifies the name of the source column in the data flow path mapping. This is a required property | |
| CodePage | Int32 | 0 | This value specifies the integer index for the code page of this column mapping type. This property applies only to column mapping types that support code pages, such as strings. Code pages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx. |
| DataType | DbType | String | This value specifies the type of the column mapping using the unified type system. |
| Direction | Direction | Input | This value specifies the role the parameter plays in the query - input, output, or return value. |
| IsUsed | Boolean | True | This value specifies whether the dataflow column is used. |
| Length | Int32 | 0 | This value specifies the length of the column mapping type. This property applies only to column mapping types that support a length specification, such as string and binary types. |
| Precision | Int32 | 0 | This value specifies the precision or the number of digits in a column mapping type. This property only applies to column mapping types that support precision, such as decimal. |
| Scale | Int32 | 0 | This value specifies the precision, or the number of digits, in a column mapping type. This property applies only to column mapping types that support precision, such as decimal. |
| SortKeyPosition | Int32 | 0 | This value specifies where the parent column is situated in the sort order. For example if the rows were first sorted by 2 other columns, then the value would be 3. If this column was not used for sorting, it's value should be 0. |
| SsisDataTypeOverride | SsisDataType | Varigence.Utility.DataType.SsisDataType.DT_EMPTY | Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the DataType property. |
| TargetColumn | String | This value specifies the name of the destination column in the data flow path mapping. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |