master_facts.dtsx

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

        <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="4" sourceattachpoint="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="2435" y="6751" />
      <point x="2435" y="7022" />
      <point x="9181" y="7022" />
      <point x="9181" y="7294" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="500" top="3754" logicalid="25" controlid="10" masterid="14" 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="{b80e8d63-cb0e-4ad5-a3cc-719498522c0c}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="1868" top="2397" logicalid="26" controlid="11" masterid="0" hint1="0" hint2="0" width="831" height="1857" 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="{3D15BD91-401D-46E2-B4AC-C898D025793D}" 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="1" destid="10" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="2267" y="2796" />
      <point x="2267" y="3275" />
      <point x="2299" y="3275" />
      <point x="2299" y="3754" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="1350" top="4519" logicalid="27" controlid="12" masterid="0" hint1="0" hint2="0" width="1485" height="1568" 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="{FBA40585-18B2-4E8B-86EC-D1DBFBB475EC}" 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="10" destid="5" sourceattachpoint="5" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="1749" y="4918" />
      <point x="1749" y="5419" />
      <point x="2435" y="5419" />
      <point x="2435" y="5587" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-5985" top="4358" logicalid="28" controlid="13" masterid="14" 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="0" snaptogrid="0">
    <control>
      <ddsxmlobjectstreaminitwrapper binary="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61bd005400680065002000730074006f007200650064002000700072006f006300200061006e0064002000730074006100670069006e00670020007400610062006c006500730020006100720065002000750073006500640020006200790020000d000a0046006100630074004f00720064006500720073002e0064007400730078002e00200059006f007500200077006f0075006c0064006e002700740020006e006f0072006d0061006c006c00790020006300720065006100740065000d000a007400680065006d00200069006e00730069006400650020007400680065002000530053004900530020007000610063006b006100670065002e00200057006500270072006500200064006f0069006e0067002000690074000d000a006800650072006500200074006f002000730069006d0070006c0069006600790020007400680065002000700072006f0063006500730073002c00200061006e0064002000610076006f006900640020006500720072006f00720073002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />