Sql Server Management Connection Element

API Type:

X-Ref:

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
SqlServerName	String		This value specifies the SQL Server where the database is stored. 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.
Password	String		This value provides the password to use for the connection if Windows Authentication is not used.
UserName	String		This value provides the username to use for the connection if Windows Authentication is not used.
UseWindowsAuthentication	Boolean	True	This value specifies whether Windows Authentication is used to connect to the server. If Windows Authentication is used, then a user name and password are not required for the connection.

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.