Flat File Connection

Declares a tab-delimited 'FlatFileFormat' with nine columns describing a survey-data file (categories, display names, URLs, and so on), then wires a 'FlatFileConnection' to that format and an absolute file path. The columns advertise their data types, lengths, and per-column delimiters so SSIS components can read or write the file without further metadata. Adjust 'FilePath' to your own location and edit the 'Columns' list to match the file you actually have.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <FileFormats>
    <FlatFileFormat Name="FlatFileFormatSurvey" 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>
  <Connections>
    <FlatFileConnection Name="FlatFileConnection" FileFormat="FlatFileFormatSurvey" FilePath="c:\users\me\documents\myFile.txt" />
  </Connections>
</Biml>