Biml Language Reference
AdoNetConnection Element
The ADO.NET connection connects to a data source that can be accessed via a .NET Framework data provider.
Attributes
  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]

LookupProviderFactory Boolean
This value specifies whether the connection should attempt to resolve the provider name as an ADO.NET provider factory invariant name and use the provider factory to extract the connection type information. Set the value to False to avoid the lookup if it is causing connection strings not to match expectations.

[.NET API Property: LookupProviderFactory]

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]

Provider String
This value specifies the ADO.NET provider invariant name for the data provider, the assembly qualified name for the data provider’s ADO.NET factory, or the assembly qualified name for the data providers ADO.NET conneciton type. This is equivalent to the Qualifier property in SQL Server Integration Services (SSIS).

[.NET API Property: Provider]

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

[.NET API Property: Annotations]

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

[.NET API Property: Expressions]