factexchangerates.dtsx

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

  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-6974" top="10893" logicalid="71" controlid="27" masterid="0" hint1="0" hint2="0" width="2087" height="1836" 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">
          <adornment percentpos="21.0337078651685" controlid="46" width="423" height="423" side="0" behavior="2" himetric="468" distfromline="175" startobj="0" x="-7173" y="11935" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{E2DE5172-2FCA-46BB-8360-BBFC6F85792B}" 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="21" sourceattachpoint="7" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-6575" y="11292" />
      <point x="-6575" y="11760" />
      <point x="-5287" y="11760" />
      <point x="-5287" y="12229" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-15014" top="8092" logicalid="72" controlid="28" masterid="0" hint1="0" hint2="0" width="6821" height="1500" 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="00020000a51a0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61bd0045007800740072006100630074002000740068006500200062006100730069006300200068006900730074006f0072006900630061006c0020006400610074006100200066006f007200200074006800650020000d000a00450078006300680061006e0067006500520061007400650073002000660061006300740020007400610062006c0065002e00200043006f006d007000750074006500200073006f006d006500200072006f00770063006f0075006e00740073000d000a0061006e006400200065007800740072006100630074002000220072006500610073006f006e00610062006c0065006e00650073007300200063006800650063006b0073002e0022002000570072006900740065000d000a0074006800650020006500780074007200610063007400200074006f00200061002000660069006c0065002c00200074006f0020007000690063006b00200075007000200069006e00200074006800650020006e00650078007400200073007400650070002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-12791" top="12167" logicalid="73" controlid="29" masterid="0" hint1="0" hint2="0" width="6000" height="1923" 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="0002000070170000830700000300640000000500008008000080000000002a0001000000900144420100065461686f6d619f0049006e0020007400680069007300200073007400650070002c00200077006500200070006500720066006f0072006d00200073007500720072006f00670061007400650020006b006500790020000d000a006c006f006f006b007500700073002c00200061006e00640020006c006f006100640020007400680065002000660061006300740020007400610062006c0065002e002000540068006900730020007400610062006c0065000d000a0069007300200076006500720079002000730069006d0070006c0065002c0020007700690074006800200052004900200065006e0066006f007200630065006400200066006f007200200061006c006c000d000a00640069006d0065006e00730069006f006e007300200062007900200074006800650020007400720078006e002000730079007300740065006d002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="3388" top="9530" logicalid="74" controlid="30" masterid="0" hint1="0" hint2="0" width="6000" height="1500" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d613c005700650027007200650020006c0065006100760069006e0067002000740068006900730020007400610073006b002000640069007300610062006c0065006400200073006f00200077006500200064006f006e00270074000d000a00670065006e006500720061007400650020007300700061006d00210000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-6322" top="19629" logicalid="75" controlid="31" 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="{F5ED00A2-2EB0-4F8B-B06F-9EB2158ABE81}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-4586" top="10194" logicalid="76" controlid="32" masterid="0" hint1="0" hint2="0" width="6431" height="2435" 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="47" width="423" height="423" side="0" behavior="2" himetric="3584" distfromline="175" startobj="0" x="-1196" y="11636" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{6EAA3BBB-D2A3-400B-B165-82A5BA6705E4}" 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="21" destid="23" sourceattachpoint="8" destattachpoint="7" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-4187" y="12229" />
      <point x="-4187" y="11461" />
      <point x="1445" y="11461" />
      <point x="1445" y="10693" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-5136" top="12994" logicalid="77" controlid="33" masterid="0" hint1="0" hint2="0" width="814" height="4352" 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">
          <adornment percentpos="49.7693194925029" controlid="48" width="423" height="423" side="0" behavior="2" himetric="1726" distfromline="175" startobj="0" x="-5335" y="15294" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{CF3DE142-C95A-4976-90B7-F80B5657C5DD}" 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="21" destid="13" sourceattachpoint="7" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-4737" y="13393" />
      <point x="-4737" y="15119" />
      <point x="-4722" y="15119" />
      <point x="-4722" y="16846" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-5287" top="23022" logicalid="78" controlid="34" masterid="0" hint1="0" hint2="0" width="829" height="1282" 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="{D055AE79-98E8-4452-B2F3-E728453848DE}" 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="16" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-4888" y="23421" />
      <point x="-4888" y="23612" />
      <point x="-4858" y="23612" />
      <point x="-4858" y="23804" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-5121" top="17611" logicalid="79" controlid="35" masterid="0" hint1="0" hint2="0" width="998" height="2518" 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="{54D2C57A-463A-4A09-BB27-588CA4D8C41A}" 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="13" destid="31" sourceattachpoint="11" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-4722" y="18010" />
      <point x="-4722" y="18819" />
      <point x="-4523" y="18819" />