• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Flat File Connection Element

API Type:
Varigence.Languages.Biml.Connection.AstFlatFileConnectionNode
X-Ref:
  • Ast Flat File Connection Node
  • Ast Connection Base Node

Attributes

AttributeAPI TypeDefaultDescription
FileFormatAstFlatFileFormatNode 
This value specifies whether to use delimited, fixed width, or ragged right file format. This is a required reference to an existing definiton.
FilePathString 
This value specifies the complete path of the flat file to connect to. This is a required property
NameString 
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
CreateInProjectBooleanFalse
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.
CreatePackageConfigurationBooleanTrue
This value specifies whether a PackageConfiguration should be created for this connection.
DelayValidationBooleanFalse
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.
HasMultipleFilesBooleanFalse
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.
LogicalDisplayFolderStringstring.Empty
Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio.

Collection Children

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

© Varigence