<?xml version="1.0"?>
<!-- Synthetic Theory fixture 2. No customer data. -->
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationName="Microsoft.Package"
  DTS:ObjectName="SyntheticPositionLoad">
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[Landing]"
      DTS:ObjectName="Landing"
      DTS:CreationName="OLEDB">
      <DTS:ObjectData>
        <DTS:ConnectionManager DTS:ConnectionString="Data Source=synthetic;Initial Catalog=SyntheticLanding;Provider=SQLNCLI11.1;Integrated Security=SSPI;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[Staging]"
      DTS:ObjectName="Staging"
      DTS:CreationName="OLEDB">
      <DTS:ObjectData>
        <DTS:ConnectionManager DTS:ConnectionString="Data Source=synthetic;Initial Catalog=SyntheticStaging;Provider=SQLNCLI11.1;Integrated Security=SSPI;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables />
  <DTS:Executables>
    <DTS:Executable DTS:refId="Package\LoadPositions"
      DTS:ExecutableType="Microsoft.Pipeline"
      DTS:ObjectName="LoadPositions">
      <DTS:ObjectData>
        <pipeline>
          <components>
            <component name="Position Extract" componentClassID="Microsoft.OLEDBSource"
              refId="Package\LoadPositions\Position Extract">
              <properties>
                <property name="OpenRowset">raw.position_extract</property>
                <property name="AccessMode" dataType="3">0</property>
              </properties>
              <connections>
                <connection connectionManagerID="Package.ConnectionManagers[Landing]"
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output name="Position Extract Output"
                  refId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output]"
                  isErrorOut="false">
                  <outputColumns>
                    <outputColumn name="position_id"
                      lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[position_id]"
                      dataType="i4" />
                    <outputColumn name="position_amount"
                      lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[position_amount]"
                      dataType="cy" />
                    <outputColumn name="as_at_month"
                      lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[as_at_month]"
                      dataType="wstr" length="6" />
                  </outputColumns>
                </output>
              </outputs>
            </component>
            <component name="Staged Positions" componentClassID="Microsoft.OLEDBDestination"
              refId="Package\LoadPositions\Staged Positions">
              <properties>
                <property name="OpenRowset">stg.positions</property>
                <property name="AccessMode" dataType="3">3</property>
              </properties>
              <connections>
                <connection connectionManagerID="Package.ConnectionManagers[Staging]"
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input name="Staged Positions Input"
                  refId="Package\LoadPositions\Staged Positions.Inputs[Staged Positions Input]">
                  <inputColumns>
                    <inputColumn lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[position_id]"
                      cachedName="position_id" />
                    <inputColumn lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[position_amount]"
                      cachedName="position_amount" />
                    <inputColumn lineageId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output].Columns[as_at_month]"
                      cachedName="as_at_month" />
                  </inputColumns>
                </input>
              </inputs>
            </component>
          </components>
          <paths>
            <path name="Position Extract to Staged Positions"
              startId="Package\LoadPositions\Position Extract.Outputs[Position Extract Output]"
              endId="Package\LoadPositions\Staged Positions.Inputs[Staged Positions Input]" />
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
</DTS:Executable>
