Flat File Format

Declares a 'FlatFileFormat' with nine columns describing a tab-delimited file: typed name and length attributes for the string fields, a row delimiter of LF, and 'ColumnNamesInFirstDataRow="true"' so the first line is treated as a header. Defining the format on its own (rather than inline with a connection) makes it reusable across multiple FlatFileConnection objects or packages. Adjust the column list, lengths, and delimiters to match the file you intend to read or write.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <FileFormats>
    <FlatFileFormat Name="MetadataFileFormat" RowDelimiter="LF" ColumnNamesInFirstDataRow="true" IsUnicode="false">
      <Columns>
        <Column Name="Category" DataType="String" Length="128" Delimiter="Tab" CodePage="1252" />
        <Column Name="DisplayName" DataType="String" Length="256" Delimiter="Tab" />
        <Column Name="Maturity" DataType="String" Length="32" Delimiter="Tab" />
        <Column Name="Frequency" DataType="String" Length="32" Delimiter="Tab" />
        <Column Name="Status" DataType="String" Length="32" Delimiter="Tab" />
        <Column Name="CompactName" DataType="String" Length="32" Delimiter="Tab" />
        <Column Name="Url" DataType="String" Length="4000" Delimiter="Tab" />
        <Column Name="HeaderRowsToSkip" Delimiter="Tab" />
        <Column Name="DateGrain" DataType="String" Length="32" Delimiter="LF" />
      </Columns>
    </FlatFileFormat>
  </FileFormats>
</Biml>