factorders.dtsx

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

        <property name="VisibleAP" value="0" vartype="3" />
      </ddsxmlobj>
    </layoutobject>
    <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="29" destid="19" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-8613" y="8053" />
      <point x="-8613" y="8521" />
      <point x="-6775" y="8521" />
      <point x="-6775" y="8990" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-8558" top="11149" logicalid="98" controlid="35" masterid="0" hint1="0" hint2="0" width="3624" 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="00080000280e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{d7473efb-9693-409e-bbb6-231e30968980}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7695" top="9755" logicalid="99" controlid="36" masterid="0" hint1="0" hint2="0" width="1320" height="1894" 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="{C0904233-F0F8-496D-A6F7-0ACE1FBB9A3C}" 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="19" destid="35" sourceattachpoint="7" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-6775" y="10154" />
      <point x="-6775" y="10651" />
      <point x="-7296" y="10651" />
      <point x="-7296" y="11149" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7145" top="6955" logicalid="100" controlid="37" masterid="0" hint1="0" hint2="0" width="6402" height="4594" 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="66" width="423" height="423" side="0" behavior="2" himetric="4649" distfromline="175" startobj="0" x="-3770" y="9476" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{C857E76D-391C-46DE-AA61-2DE61DEF2F8F}" 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="35" destid="30" sourceattachpoint="6" destattachpoint="5" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-6746" y="11149" />
      <point x="-6746" y="9301" />
      <point x="-1143" y="9301" />
      <point x="-1143" y="7454" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-17052" top="4853" logicalid="101" controlid="38" 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="00020000a51a0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61ba0045007800740072006100630074002000740068006500200062006100730069006300200068006900730074006f0072006900630061006c0020006400610074006100200066006f007200200074006800650020000d000a0046006100630074004f00720064006500720073002000660061006300740020007400610062006c0065002e00200043006f006d007000750074006500200073006f006d006500200072006f00770063006f0075006e00740073000d000a0061006e006400200065007800740072006100630074002000220072006500610073006f006e00610062006c0065006e00650073007300200063006800650063006b0073002e0022002000570072006900740065000d000a0074006800650020006500780074007200610063007400200074006f00200061002000660069006c0065002c00200074006f0020007000690063006b00200075007000200069006e00200074006800650020006e00650078007400200073007400650070002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-14829" top="8399" logicalid="102" controlid="39" masterid="0" hint1="0" hint2="0" width="6000" height="3087" 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="00020000701700000f0c00000300640000000500008008000080000000002a0001000000900144420100065461686f6d617b0149006e0020007400680069007300200073007400650070002c0020007700650020006c006f006f006b007500700020006100200066006500770020006100640064006900740069006f006e0061006c0020007000690065006300650073000d000a006f006600200069006e0066006f0072006d006100740069006f006e002000660072006f006d00200074006800650020007400720078006e002000730079007300740065006d00730020002800630075007200720065006e00630079000d000a0061006e0064002000730061006c0065007300200072006500610073006f006e0029002e0020004d006f007300740020006f0066002000740068006900730020006400610074006100200066006c006f007700200073007400650070000d000a006900730020007300700065006e007400200069006e002000740068006500200073007500720072006f00670061007400650020006b0065007900200070006900700065006c0069006e00650020002d002d0020006c006f006f006b0069006e0067000d000a00750070002000640069006d0065006e00730069006f006e0020006b006500790073002e000d000a0045006e006400200069006e00200061002000730074006100670069006e00670020007400610062006c0065002c0020006200650063006100750073006500200077006500270072006500200067006f0069006e006700200074006f000d000a006800610076006500200074006f00200064006f002000740068006500200043007500730074006f006d006500720020006c006f006f006b0075007000200062007900200077006100790020006f0066002000610020000d000a006a006f0069006e002c00200069006e0020006f007200640065007200200074006f0020006700650074002000740068006500200063006f0072007200650063007400200068006900730074006f0072006900630061006c000d000a0043007500730074006f006d00650072004b00650079002000280054007900700065003200200053004300440029002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="-6229" top="13002" logicalid="103" controlid="40" masterid="0" hint1="0" hint2="0" width="4815" 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="00080000cf1200008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{F2AD09DF-1008-4337-BAA3-16C17B85F515}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-7145" top="11914" logicalid="104" controlid="41" masterid="0" hint1="0" hint2="0" width="3723" height="1588" 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="9.52117353999446" controlid="67" width="423" height="423" side="0" behavior="2" himetric="344" distfromline="175" startobj="0" x="-7344" y="12832" visible="1" allowoverlap="1" usepercent="1" />
        </polyline>
      </ddsxmlobj>
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{3E7F9132-97E8-48EC-B852-BF0D7ECB48DB}" 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="35" destid="40" sourceattachpoint="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="-6746" y="12313" />
      <point x="-6746" y="12657" />
      <point x="-3822" y="12657" />
      <point x="-3822" y="13002" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-7240" top="285" logicalid="105" controlid="42" masterid="53" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61920049006600200079006f0075002000770061006e007400200074006f0020006c006f006f006b00200061007400200074006800650020007000610063006b0061006700650020004200450046004f0052004500200079006f0075000d000a0065007800650063007500740065002000690074002c00200079006f0075002000730068006f0075006c006400200066006900720073007400200065007800650063007500740065002000740068006900730020007400610073006b002e000d000a004900740020006300720065006100740065007300200032002000730074006100670069006e00670020007400610062006c00650073002000750073006500640020006c006100740065007200200069006e002000740068006500200070006b0067002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-6642" top="24754" logicalid="107" controlid="44" masterid="46" 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="{f7ff905c-1bce-4bd1-bc2c-09eb2fcf5bf4}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" grou