<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:ExecutableType="Microsoft.Package" DTS:ObjectName="LoadOrders">
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager DTS:ObjectName="SourceDB" DTS:DTSID="{AAA}" DTS:CreationName="OLEDB"/>
  </DTS:ConnectionManagers>
  <DTS:Executables>
    <DTS:Executable DTS:refId="Package\Truncate staging"
      DTS:ExecutableType="Microsoft.ExecuteSQLTask" DTS:ObjectName="Truncate staging">
      <DTS:ObjectData>
        <SQLTask:SqlTaskData xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"
          SQLTask:SqlStatementSource="TRUNCATE TABLE staging_orders"/>
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable DTS:refId="Package\Load Orders"
      DTS:ExecutableType="Microsoft.Pipeline" DTS:ObjectName="Load Orders">
      <DTS:ObjectData>
        <pipeline>
          <components>
            <component refId="Package\Load Orders\OLE DB Source"
              componentClassID="Microsoft.OLEDBSource" name="OLE DB Source">
              <properties>
                <property name="OpenRowset">[dbo].[Orders]</property>
                <property name="SqlCommand"></property>
              </properties>
              <connections>
                <connection refId="Package\Load Orders\OLE DB Source.Connections[OleDbConnection]"
                  connectionManagerID="{AAA}"
                  connectionManagerRefId="Package.ConnectionManagers[SourceDB]" name="OleDbConnection"/>
              </connections>
              <outputs>
                <output refId="Package\Load Orders\OLE DB Source.Outputs[OLE DB Source Output]"
                  name="OLE DB Source Output">
                  <outputColumns>
                    <outputColumn refId="c1" dataType="i4" name="OrderID" lineageId="101"/>
                    <outputColumn refId="c2" dataType="wstr" length="50" name="Region" lineageId="102"/>
                    <outputColumn refId="c3" dataType="r8" name="Sales" lineageId="103"/>
                  </outputColumns>
                </output>
                <output refId="Package\Load Orders\OLE DB Source.Outputs[OLE DB Source Error Output]"
                  name="OLE DB Source Error Output" isErrorOut="true"/>
              </outputs>
            </component>
            <component refId="Package\Load Orders\Derived Column"
              componentClassID="Microsoft.DerivedColumn" name="Derived Column">
              <inputs>
                <input refId="Package\Load Orders\Derived Column.Inputs[Derived Column Input]"
                  name="Derived Column Input"/>
              </inputs>
              <outputs>
                <output refId="Package\Load Orders\Derived Column.Outputs[Derived Column Output]"
                  name="Derived Column Output">
                  <outputColumns>
                    <outputColumn refId="c4" dataType="r8" name="SalesWithTax" lineageId="104">
                      <properties>
                        <property name="Expression">#103 * 1.2</property>
                        <property name="FriendlyExpression">[Sales] * 1.2</property>
                      </properties>
                    </outputColumn>
                  </outputColumns>
                </output>
              </outputs>
            </component>
            <component refId="Package\Load Orders\OLE DB Destination"
              componentClassID="Microsoft.OLEDBDestination" name="OLE DB Destination">
              <properties>
                <property name="OpenRowset">[dbo].[OrdersOut]</property>
              </properties>
              <inputs>
                <input refId="Package\Load Orders\OLE DB Destination.Inputs[OLE DB Destination Input]"
                  name="OLE DB Destination Input"/>
              </inputs>
            </component>
          </components>
          <paths>
            <path refId="p1"
              startId="Package\Load Orders\OLE DB Source.Outputs[OLE DB Source Output]"
              endId="Package\Load Orders\Derived Column.Inputs[Derived Column Input]"/>
            <path refId="p2"
              startId="Package\Load Orders\Derived Column.Outputs[Derived Column Output]"
              endId="Package\Load Orders\OLE DB Destination.Inputs[OLE DB Destination Input]"/>
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
</DTS:Executable>
