Biml Language Reference
OdbcConnection Element
The ODBC Connection specifies the settings necessary for an Open Database Connectivity (ODBC) adapter installed on the system to connect to a data source.
  Attribute API Type Default Description
ConnectionString String
This value specifies how to open the connection for the specified data source.

[.NET API Property: ConnectionString]

CreateInProject Boolean
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.

[.NET API Property: CreateInProject]

CreatePackageConfiguration Boolean
This value specifies whether a PackageConfiguration should be created for this connection.

[.NET API Property: CreatePackageConfiguration]

DelayValidation Boolean
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.

[.NET API Property: DelayValidation]

LogicalDisplayFolder String
Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio.

[.NET API Property: LogicalDisplayFolder]

MaxActiveConnections Int32
This value specifies the maximum number of concurrent connections allowed.

[.NET API Property: MaxActiveConnections]

Name String
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.

[.NET API Property: Name]

RetainSameConnection Boolean
This value indicates whether the same connection can be used for multiple tasks.

[.NET API Property: RetainSameConnection]

Singleton Children
  Child API Type Description
<AnalysisMetadata /> AstAnalysisServicesConnectionMetadataNode
Specifies supplemental information that is used by SQL Server Analysis Services (SSAS) to connect to a given data source.

[.NET API Property: AnalysisMetadata]

Collection Children
  Child API Type Description
    <Annotation />
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.

[.NET API Property: Annotations]

    <Expression />
This is a collection of SSIS expression definitions for connection property value overrides.

[.NET API Property: Expressions]