factexchangerates.dtsx

数据仓库开发的很好的一个例子

    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{25119944-51D6-4B9E-A8B4-D0C9D5122226}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="6" destid="17" sourceattachpoint="19" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-6492" y="6497" />
      <point x="-6492" y="7312" />
      <point x="-6456" y="7312" />
      <point x="-6456" y="8127" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-9037" top="1606" logicalid="63" controlid="19" masterid="39" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="0" snaptogrid="0">
    <control>
      <ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{21ab3dfe-d642-4eea-bf9f-09a36e67143e}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7642" top="395" logicalid="64" controlid="20" masterid="0" hint1="0" hint2="0" width="804" height="1711" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="0" snaptogrid="0">
    <control>
      <ddsxmlobj>
        <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{E6A29151-5232-49D4-831E-93406181A751}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="5" destid="19" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-7243" y="794" />
      <point x="-7243" y="1200" />
      <point x="-7238" y="1200" />
      <point x="-7238" y="1606" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="-6536" top="12229" logicalid="65" controlid="21" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{86738ABD-CF54-4D00-9661-E411F11A9EBA}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-8400" top="10128" logicalid="66" controlid="22" masterid="0" hint1="0" hint2="0" width="3651" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobjectstreaminitwrapper binary="00080000430e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{17024702-cad0-4545-a1c6-cb5dfd8d2c22}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Send Mail Task" left="-354" top="9529" logicalid="67" controlid="23" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{2AEDC6C3-9414-4C25-AEE1-5EEE30F8A6B4}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-6305" top="8892" logicalid="68" controlid="24" masterid="0" hint1="0" hint2="0" width="8150" height="1137" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobj>
        <polyline endtypedst="3" endtypesrc="1" usercolor="255" linestyle="1" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{87FA2A73-2529-4B19-8617-4B929D6262DD}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="17" destid="23" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-5906" y="9291" />
      <point x="-5906" y="9410" />
      <point x="1445" y="9410" />
      <point x="1445" y="9529" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7405" top="8892" logicalid="69" controlid="25" masterid="0" hint1="0" hint2="0" width="1230" height="1736" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobj>
        <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{75A654F7-5F17-4FDD-B258-4AC643220FC0}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="17" destid="22" sourceattachpoint="5" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-7006" y="9291" />
      <point x="-7006" y="9918" />
      <point x="-6575" y="9918" />
      <point x="-6575" y="10128" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-5148" top="9712" logicalid="70" controlid="26" masterid="0" hint1="0" hint2="0" width="5094" height="1398" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
    <control>
      <ddsxmlobj>
        <polyline endtypedst="3" endtypesrc="1" usercolor="255" linestyle="1" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1">
          <adornment percentpos="50" controlid="45" width="423" height="423" side="0" behavior="2" himetric="2497" distfromline="175" startobj="0" x="-2376" y="10586" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{17B71DA0-4229-4A26-B9E0-21D0B107DAA5}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="22" destid="23" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-4749" y="10710" />
      <point x="-2551" y="10710" />
      <point x="-2551" y="10111" />
      <point x="-354" y="10111" />
    </connector>