Odbc Connection Element
X-Ref:
- Ast Odbc Connection Node
- Ast Db Connection Node
- Ast Connection Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| ConnectionString | String | This value specifies how to open the connection for the specified data source. This is a required property | |
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| CreateInProject | Boolean | False | This value specifies whether the Connection should be created as a ConnectionManager within each SSIS package that uses it or as a shared ConnectionManager for each project that uses it. |
| CreatePackageConfiguration | Boolean | True | This value specifies whether a PackageConfiguration should be created for this connection. |
| DelayValidation | Boolean | False | This value indicates that the connection should not be validated (tested to make sure that it points to a valid resource) until immediately before it is used. |
| LogicalDisplayFolder | String | string.Empty | Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio. |
| MaxActiveConnections | Int32 | 0 | This value specifies the maximum number of concurrent connections allowed. |
| RetainSameConnection | Boolean | False | This value indicates whether the same connection can be used for multiple tasks. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <AnalysisMetadata /> | AstAnalysisServicesConnectionMetadataNode | The SQL Server Analysis Services (SSAS) connection information node specifies supplemental information that is used by SSAS to connect to a given data source, usually in context of development and cube processing. |
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. |
| <Expressions> <Expression /> </Expressions> | AstPropertyExpressionNode | This is a collection of SSIS expression definitions for connection property value overrides. |