kg_scdcustom.dtsx

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

      <point x="3961" y="17639" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Destination" left="12534" top="12587" logicalid="46" controlid="16" 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="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/components/1551" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Destination" left="2188" top="20623" logicalid="47" 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="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/components/1603" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Destination" left="8670" top="15405" logicalid="48" controlid="18" masterid="0" hint1="0" hint2="0" width="4842" 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="00080000ea1200008c040000" />
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/components/1934" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="5514" top="15588" logicalid="49" controlid="19" masterid="0" hint1="0" hint2="0" width="3456" height="854" 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"><adornment percentpos="41.7140825035562" controlid="32" width="749" height="344" side="0" behavior="2" himetric="1173" distfromline="175" startobj="0" x="7236" y="16217" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/paths/1996" 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="9" destid="18" sourceattachpoint="15" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="5913" y="16042" />
      <point x="7291" y="16042" />
      <point x="7291" y="15987" />
      <point x="8670" y="15987" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="16422" top="12366" logicalid="50" controlid="20" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d619800540068006500200022006500720072006f007200200072006f00770073002200200061007200650020006e0065007700200063007500730074006f006d006500720073002e002000540068006500790020006600610069006c0020000d000a0074006800650020006c006f006f006b0075007000200062006500630061007500730065002000740068006500790027007200650020006e006f007400200069006e0020007400680065002000430075007300740020000d000a00640069006d0065006e00730069006f006e0020007900650074002e00200053006f002000730069006d0070006c007900200061006400640020007400680065006d00200074006f00200074006800650020000d000a00640069006d0065006e00730069006f006e0020007400610062006c0065002e0000000000" />
    </control>
    <layoutobject><ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="13989" top="15382" logicalid="51" controlid="21" masterid="0" hint1="0" hint2="0" width="6000" height="2796" 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="0002000070170000ec0a00000300640000000500008008000080000000002a0001000000900144420100065461686f6d611f015400790070006500310020007500700064006100740065007300200043004f0055004c004400200062006500200070006500720066006f0072006d006500640020007500730069006e0067000d000a007400680065002000530051004c00200043006f006d006d0061006e0064002000280061007300200077006500200064006f00200066006f00720020007400680065002000270066006f0072006d00650072006c0079000d000a00630075007200720065006e007400200072006f00770027002000620065006c006f00770029002e00200048006f00770065007600650072002c00200074006f002000670065007400200068006900670068006500730074000d000a0070006500720066006f0072006d0061006e00630065002c00200079006f007500270064002000640075006d0070002000740068006500200069006d0061006700650020006f00660020007400680065000d000a0072006f0077007300200074006f0020006200650020007500700064006100740065006400200069006e0074006f002000610020007400610062006c0065002e00200041006600740065007200200074006800690073000d000a006400610074006100200066006c006f007700200065006e00640073002c0020007700650027006c006c00200070006500720066006f0072006d00200061002000620075006c006b002000750070006400610074006500200069006e000d000a0061002000530051004c002000530074006100740065006d0065006e00740020007400610073006b002e0000000000" />
    </control>
    <layoutobject><ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="6078" top="17073" logicalid="52" controlid="22" masterid="0" hint1="0" hint2="0" width="6000" height="2982" 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="0002000070170000a60b00000300640000000500008008000080000000002a0001000000900144420100065461686f6d612101540068006500200072006f007700200066006f0072006d00650072006c00790020006b006e006f0077006e002000610073002000630075007200720065006e00740020006e006500650064007300200074006f000d000a006200650020007500700064006100740065006400200066006f007200200054007900700065002000320020006300680061006e006700650073002e0020005700650020006300680061006e00670065000d000a007400680065002000630075007200720065006e007400200072006f007700200069006e00640069006300610074006f007200200074006f00200027006e0027002c00200061006e0064002000740068006500200052006f0077000d000a0045006e00640020004400610074006500200074006f002000740068006500200064006100790020006200650066006f007200650020007900650073007400650072006400610079002e000d000a000d000a0049006600200079006f007500200068006100760065002000680075006700650020006400610069006c007900200069006e006300720065006d0065006e00740061006c00200076006f006c0075006d00650073002c0020000d000a0079006f00750027006400200066006c006f007700200072006f007700200069006d006100670065007300200074006f00200061002000730074006100670069006e00670020007400610062006c006500200061006e00640020000d000a0070006500720066006f0072006d00200061002000620075006c006b00200069006e0073006500720074002e0000000000" />
    </control>
    <layoutobject><ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="6051" top="20591" logicalid="53" controlid="23" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d614e0049006e0073006500720074002000610020006e0065007700200072006f007700200066006f007200200074006800690073002000640069006d0065006e00730069006f006e0020006d0065006d006200650072000d000a0069006e0074006f002000740068006500200043007500730074006f006d00650072002000640069006d0065006e00730069006f006e0020007400610062006c0065002e0000000000" />
    </control>
    <layoutobject><ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Updates column values using expressions" left="7347" top="12552" logicalid="54" controlid="24" 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="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/components/2342" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="5434" top="12551" logicalid="55" controlid="25" masterid="0" hint1="0" hint2="0" width="2213" height="983" 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="19.3168433451119" controlid="33" width="2826" height="344" side="0" behavior="2" himetric="328" distfromline="175" startobj="0" x="4858" y="13125" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject><ddsxmlobj><property name="LogicalObject" value="{312725BA-07C0-4FEF-B82D-E715D193E9E4}/paths/2348" 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="24" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="5833" y="12950" />
      <point x="6590" y="12950" />
      <point x="6590" y="13134" />