dimdate.dtsx

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

  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Conversion" left="2456" top="368" logicalid="37" controlid="13" 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/3441" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3654" top="-1651" logicalid="38" controlid="14" masterid="0" hint1="0" hint2="0" width="1001" height="2519" 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/3447" 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="13" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="4053" y="-1252" />
      <point x="4053" y="-442" />
      <point x="4255" y="-442" />
      <point x="4255" y="368" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3623" top="1133" logicalid="39" controlid="15" masterid="0" hint1="0" hint2="0" width="1032" height="2370" 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/3536" 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="1" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="4255" y="1532" />
      <point x="4255" y="2267" />
      <point x="4022" y="2267" />
      <point x="4022" y="3003" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="5681" top="7111" logicalid="40" controlid="16" masterid="0" hint1="0" hint2="0" width="2875" height="933" 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="79.4372294372294" controlid="27" width="5363" height="318" side="0" behavior="2" himetric="1835" distfromline="175" startobj="0" x="4835" y="7685" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{39D8225F-9925-469E-96F3-E2F271DAC707}/paths/3607" 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="11" destid="4" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="6080" y="7644" />
      <point x="7168" y="7644" />
      <point x="7168" y="7510" />
      <point x="8256" y="7510" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Loads raw data into a file." left="13463" top="6823" logicalid="41" controlid="17" 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/3608" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="11455" top="7006" logicalid="42" controlid="18" masterid="0" hint1="0" hint2="0" width="2308" height="904" 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/3614" 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="4" destid="17" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="11854" y="7510" />
      <point x="12658" y="7510" />
      <point x="12658" y="7405" />
      <point x="13463" y="7405" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Evaluates and directs rows in a dataset." left="2298" top="-5056" logicalid="43" controlid="19" 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/3898" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3645" top="-6598" logicalid="44" controlid="20" masterid="0" hint1="0" hint2="0" width="852" height="2042" 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/3905" 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="19" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="4044" y="-6199" />
      <point x="4044" y="-5628" />
      <point x="4097" y="-5628" />
      <point x="4097" y="-5056" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="3654" top="-4291" logicalid="45" controlid="21" masterid="0" hint1="0" hint2="0" width="843" height="2375" 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="