Cache Connection

Declares a 'RawFileFormat' named 'MyRawFileFormat' with three indexed columns (ID, CacheSize, Description) and a 'CacheConnection' that references that format by name. SSIS Lookup transformations can read from a Cache Connection that has been populated by a Cache Transform earlier in the package, which avoids hitting the source database on every package run. Set 'IndexPosition="0"' on the column you intend to use as the lookup key.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <FileFormats>
    <RawFileFormat Name="MyRawFileFormat">
      <Columns>
        <Column Name="ID" IndexPosition="0" />
        <Column Name="CacheSize" DataType="Int32" IndexPosition="1" />
        <Column Name="Description" DataType="String" Length="200" IndexPosition="2" />
      </Columns>
    </RawFileFormat>>
  </FileFormats>
  <Connections>
    <CacheConnection Name="MyCacheConnection" RawFileFormatName="MyRawFileFormat" />
  </Connections>
</Biml>