dimcurrency.dtsx

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

    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3184" 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="8" destid="10" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="10998" y="6174" />
      <point x="12143" y="6174" />
      <point x="12143" y="6183" />
      <point x="13289" y="6183" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Looks up values in a reference dataset by using exact matching." left="2335" top="8141" logicalid="35" controlid="12" 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="{39D8225F-9925-469E-96F3-E2F271DAC707}/components/3193" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3613" top="6366" logicalid="36" controlid="13" masterid="0" hint1="0" hint2="0" width="921" height="2275" 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="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3208" 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="12" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4012" y="6765" />
      <point x="4012" y="7453" />
      <point x="4134" y="7453" />
      <point x="4134" y="8141" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="6913" top="8062" logicalid="37" controlid="14" masterid="0" hint1="0" hint2="0" width="6794" height="2109" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="000200008a1a00003d0800000300640000000500008008000080000000002a0001000000900144420100065461686f6d611d014f007500720020006d00610069006e00200065007800740072006100630074002000700075006c006c007300200061006c006c002000630075007200720065006e0063007900200063006f006400650073002000660072006f006d000d000a00740068006500200073006f0075007200630065002000730079007300740065006d002e00200057006500200061006c0073006f002000770061006e007400200074006f0020006b006e006f00770020000d000a007700680069006300680020006f006600200074006800650073006500200063006f0064006500730020006100720065002000610063007400750061006c006c007900200075007300650064002000280073006f002000770065000d000a00630061006e00200065006100730069006c00790020006c0069006d0069007400200075007300650072007300270020007600690065007700200074006f0020006f006e006c00790020007400680065002000720065006c006500760061006e0074000d000a0063006f0064006500730029002e0020004e006f0074006500200074006800610074002000740068006900730020004c006f006f006b0075007000200069007300200063006f006e006600690067007500720065006400200074006f000d000a00700061007300730020006f006e00200061006e00790020004c006f006f006b007500700020006600610069006c0075007200650073002e0020005400680069007300200069007300200069006e00740065006e00740069006f006e0061006c002e0000000000" />
    </control>
    <layoutobject><ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Updates column values using expressions" left="2273" top="10364" logicalid="38" controlid="15" 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="{39D8225F-9925-469E-96F3-E2F271DAC707}/components/3233" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3673" top="8906" logicalid="39" controlid="16" masterid="0" hint1="0" hint2="0" width="861" height="1958" 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="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3239" 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="12" destid="15" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4134" y="9305" />
      <point x="4134" y="9834" />
      <point x="4072" y="9834" />
      <point x="4072" y="10364" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3450" top="11129" logicalid="40" controlid="17" masterid="0" hint1="0" hint2="0" width="1022" height="2270" 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="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3252" 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="15" destid="2" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4072" y="11528" />
      <point x="4072" y="12213" />
      <point x="3849" y="12213" />
      <point x="3849" y="12899" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Destination" left="2298" top="16899" logicalid="41" controlid="18" 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="{39D8225F-9925-469E-96F3-E2F271DAC707}/components/3266" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3476" top="15596" logicalid="42" controlid="19" masterid="0" hint1="0" hint2="0" width="1021" height="1803" 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="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3283" 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="3" destid="18" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="3875" y="15995" />
      <point x="3875" y="16447" />
      <point x="4097" y="16447" />
      <point x="4097" y="16899" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="5497" top="17007" logicalid="43" controlid="20" masterid="0" hint1="0" hint2="0" width="2886" height="874" 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="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"><adornment percentpos="80.0618921308576" controlid="24" width="4499" height="344" side="0" behavior="2" himetric="1811" distfromline="175" startobj="0" x="5059" y="17581" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3310" 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="18" destid="5" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="5896" y="17481" />
      <point x="6989" y="17481" />
      <point x="6989" y="17406" />
      <point x="8083" y="17406" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Loads raw data into a file." left="13596" top="16820" logicalid="44" 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="{39D8225F-9925-469E-96F3-E2F271DAC707}/components/3311" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="11282" top="17003" logicalid="45" controlid="22" masterid="0" hint1="0" hint2="0" width="2614" height="803" 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="1" customendtypedstid="0" customendtypesr