Flat File Connection Element
X-Ref:
- Ast Flat File Connection Node
- Ast Connection Base Node
Attributes
Attribute | API Type | Default | Description |
---|---|---|---|
FileFormat | AstFlatFileFormatNode | This value specifies whether to use delimited, fixed width, or ragged right file format. This is a required reference to an existing definiton. | |
FilePath | String | This value specifies the complete path of the flat file to connect to. 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. |
HasMultipleFiles | Boolean | False | Specifies whether or not a MultiFlatFile connection manager should be used for this flat file connection. If this property is set to true, then pipe (|) separated and wildcard paths can be specified in the FilePath property. See http://msdn.microsoft.com/en-us/library/ms137830.aspx for more details. |
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. |
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. |