dimdate.dtsx

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

    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-9901" top="8511" logicalid="35" controlid="11" masterid="0" hint1="0" hint2="0" width="844" height="1852" 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="{3783C628-C8FE-4416-91F7-7A1A84357E0D}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector sourceid="2" destid="5" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-9457" y="8910" />
      <point x="-9457" y="9386" />
      <point x="-9502" y="9386" />
      <point x="-9502" y="9863" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-9962" top="4411" logicalid="36" controlid="12" masterid="0" hint1="0" hint2="0" width="837" height="2089" 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="{BE7F1666-520A-4ED5-A9EF-FDC6AE307F81}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector sourceid="1" destid="4" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-9563" y="4810" />
      <point x="-9563" y="5405" />
      <point x="-9525" y="5405" />
      <point x="-9525" y="6000" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7456" top="845" logicalid="37" controlid="13" masterid="0" hint1="0" hint2="0" width="1653" height="1856" 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="{5AE2CDEB-04BC-4AD8-A32F-9843C870B64D}" 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="7" destid="9" sourceattachpoint="7" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-7057" y="1244" />
      <point x="-7057" y="1722" />
      <point x="-6203" y="1722" />
      <point x="-6203" y="2201" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-7610" top="15560" logicalid="38" controlid="14" masterid="17" 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="{857a0480-c247-4448-918c-6a8a3da9869d}" 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="-7715" top="13473" logicalid="39" controlid="15" masterid="17" 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="{5F9BFE9A-2F9E-4177-A6A2-97A9EE0C390B}" 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="-7583" top="17336" logicalid="40" controlid="16" masterid="17" 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="{6FE6B3D4-DC27-47F0-A403-888D56AD5EFB}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="Sequence Container" left="-8550" top="11930" logicalid="41" controlid="17" masterid="0" hint1="0" hint2="0" width="5862" 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="00080000e61600008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="Caption" value="Update auditing metadata" vartype="8" />
        <property name="CaptionHeight" value="1164" vartype="3" />
        <property name="Collapsed" value="-1" vartype="11" />
        <property name="CollapsedWidth" value="5862" vartype="3" />
        <property name="LogicalObject" value="{F88B415E-8981-49A7-B464-CBD90FAB1ECA}" vartype="8" />
        <property name="RealHeight" value="8729" vartype="3" />
        <property name="RealWidth" value="5862" vartype="3" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-6210" top="16325" logicalid="42" controlid="18" masterid="0" hint1="0" hint2="0" width="826" height="1511" 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="{648455AE-1051-4671-813E-889F22B95E0A}" vartype="8" />
        <property name="Virtual" value="0" vartype="11" />
        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector sourceid="14" destid="16" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-5811" y="16724" />
      <point x="-5811" y="17030" />
      <point x="-5784" y="17030" />
      <point x="-5784" y="17336" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-6315" top="14238" logicalid="43" controlid="19" masterid="0" hint1="0" hint2="0" width="904" height="1822" 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>