Sql Server Dqs Connection Element
X-Ref:
- Ast Sql Server Dqs Connection Node
- Ast Connection Base Node
Attributes
Attribute | API Type | Default | Description |
---|---|---|---|
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 | |
Server | String | Specifies that name of the server where the SQL Server DQS instance is hosted. 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. |
Qualifier | String | Specifies the qualifier that should be used for the connection. | |
TargetServerVersion | SqlServerVersion | SqlServer2016 | Specifies the version of the target DQS server. This is a new option introduced in SSIS 2016. It defaults to SqlServer2016. |
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. |