master_dims.dtsx

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

    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="4061" top="8773" logicalid="47" controlid="18" masterid="0" hint1="0" hint2="0" width="6000" height="2241" 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="0002000070170000c10800000300640000000500008008000080000000002a0001000000900144420100065461686f6d61cf005400680069007300200044006100740065002000640069006d0065006e00730069006f006e0020007000610063006b0061006700650020006c006f006100640073002000660072006f006d00200061006e000d000a0045007800630065006c002000660069006c0065002e00200059006f007500200064006f0020006e00650065006400200074006f0020006f00700065006e0020007400680065002000440061007400650020000d000a007000610063006b00610067006500200061006e006400200065006e0073007500720065002000740068006500200063006f006e006e0065006300740069006f006e00200069007300200070006f0069006e00740069006e0067000d000a0074006f002000740068006500200063006f007200720065006300740020006400690072006500630074006f0072007900200028007400680065002000730061006d0065002000700061007400680020007700680065007200650020000d000a0074006800650020007000610063006b006100670065007300200061007200650020006c006f006300610074006500640029002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Script Task" left="-280" top="572" logicalid="48" controlid="19" masterid="27" 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="{6EA9941D-E92D-4D06-BE08-ED216A84AB6B}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="948" top="-463" logicalid="49" controlid="20" masterid="0" hint1="0" hint2="0" width="971" height="1535" 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="{6A67724E-E06A-4F20-AAC5-3EE224237A1D}" 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="6" destid="19" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="1347" y="-64" />
      <point x="1347" y="254" />
      <point x="1519" y="254" />
      <point x="1519" y="572" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="-6768" top="-1002" logicalid="50" controlid="21" masterid="0" hint1="0" hint2="0" width="8137" height="1974" 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="{1DBE2E86-8177-4E0C-B450-EF4E5E7EADE7}" 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="1" sourceattachpoint="4" destattachpoint="7" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
      <point x="969" y="572" />
      <point x="969" y="34" />
      <point x="-6369" y="34" />
      <point x="-6369" y="-503" />
    </connector>
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="-8243" top="508" logicalid="51" controlid="22" masterid="27" hint1="0" hint2="0" width="7667" 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="00020000f31d0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61ca004d006f0064006900660079002000740068006500200065007800740072006100630074002000720061006e0067006500200066006f00720020007400680065002000640069006d0065006e00730069006f006e000d000a00700072006f00630065007300730069006e00670020007000610063006b0061006700650073002e002000540068006900730020006900730020006100200077006f0072006b00610072006f0075006e006400200066006f0072000d000a0061006e0020006f0064006400690074007900200069006e002000740068006500200041006400760065006e00740075007200650057006f0072006b0073002000640065006d006f002000640061007400610062006100730065002e0020004e006f0072006d0061006c006c0079000d000a0079006f007500200077006f0075006c00640020006e006f00740020006800610076006500200073007500630068002000610020007400610073006b00200069006e00200079006f007500720020006d006100730074006500720020007000610063006b006100670065002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-601" top="-2883" logicalid="52" controlid="23" masterid="27" 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="{5cf498ea-b67c-4fca-8372-e60773f2b459}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Polyline" left="799" top="-2118" logicalid="53" controlid="24" masterid="0" hint1="0" hint2="0" width="948" height="1390" 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>