2SQL2005PC\AdministratorSQL2005PC2/20/2006 9:32:58 PM51-101024{D13B4E10-A129-44D6-BB80-2ACC788DDCC0}0000
0CHICAGO.AdventureWorks{77C189B5-8FE7-4C98-B80C-BA7EDE929373}OLEDB0Data Source=.;Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
0CHICAGO.AdventureWorksDW{48D66ADC-386B-451C-823D-CBAEA6441E50}OLEDB0Data Source=.;Initial Catalog=AdventureWorksDW;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
<Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>1000</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="10" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="32597" y="10954" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="1000" top="1000" logicalid="4" controlid="1" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}" 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="1000" top="3144" logicalid="5" controlid="2" 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="{1EC908D3-FBBE-4C22-80A5-C7DBAE47BEBA}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="2400" top="1765" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="1879" 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="{80702163-FF96-44C3-9ACE-FDD7E016995E}" 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="2" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="2799" y="2164" />
<point x="2799" y="3144" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{58F72197-F395-4DEB-B23B-112EA9EBC885}{2031E191-4257-4BEF-8496-F3EB0BC864A1}
<PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{80702163-FF96-44C3-9ACE-FDD7E016995E}{9D713F17-6056-481B-9B10-73A48C8FE297}
<TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>-5210</dwd:BoundingLeft><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="78" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-10165" scrolltop="402" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="32597" y="10028" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Source" left="-5209" top="1402" logicalid="36" controlid="1" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Updates column values using expressions" left="-5209" top="3678" logicalid="37" controlid="2" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/160" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-3809" top="2167" logicalid="38" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2011" 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" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/paths/166" 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="2" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-3410" y="2566" />
<point x="-3410" y="3678" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Looks up values in a reference dataset by using exact matching." left="-5209" top="5953" logicalid="39" controlid="4" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/226" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-3809" top="4443" logicalid="40" controlid="5" masterid="0" hint1="0" hint2="0" width="799" height="2010" 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" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/paths/241" 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="2" destid="4" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-3410" y="4842" />
<point x="-3410" y="5953" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Updates column values using expressions" left="-5209" top="8122" logicalid="41" controlid="6" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/262" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-3809" top="6718" logicalid="42" controlid="7" masterid="0" hint1="0" hint2="0" width="799" height="1904" 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" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/paths/268" 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="4" destid="6" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-3410" y="7117" />
<point x="-3410" y="8122" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Looks up values in a reference dataset by using exact matching." left="-5209" top="10318" logicalid="43" controlid="8" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/362" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-3809" top="8887" logicalid="44" controlid="9" masterid="0" hint1="0" hint2="0" width="799" height="1931" 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" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/paths/377" 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="8" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-3410" y="9286" />
<point x="-3410" y="10318" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Looks up values in a reference dataset by using exact matching." left="-5210" top="12542" logicalid="45" controlid="10" 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="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/components/424" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-3810" top="11083" logicalid="46" controlid="11" masterid="0" hint1="0" hint2="0" width="800" height="1959" 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" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9330370C-A40F-40E5-A563-F5DC23F78ABC}/paths/439" 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="8" destid="10" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-3410" y="11482" />
<point x="-3410" y="12012" />
<point x="-3411" y="12012" />
<point x="-3411" y="12542" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1134" top="1429" logicalid="47" controlid="12" masterid="0" hint1="0" hint2="0" width="4174" 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="000200004e100000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61520052006500740072006900650076006500200061006c006c00200045006d0070006c006f007900650065002000640065007400610069006c0073000d000a00660072006f006d002000740068006500200045006d0070006c006f007900650065002c00200043006f006e007400610063007400200061006e0064000d000a00530061006c006500730050006500720073006f006e0020007400610062006c00650073002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1161" top="3704" logicalid="48" controlid="13" masterid="0" hint1="0" hint2="0" width="4915" height="1209" 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="0002000033130000b90400000300640000000500008008000080000000002a0001000000900144420100065461686f6d61400041006400640020007400680065002000530061006c006500730050006500720073006f006e0046006c0061006700200061006e0064000d000a00530061006c00650073005400650072007200690074006f007200790041006c007400650072006e006100740065004b0065007900200063006f006c0075006d006e0073002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1161" top="5901" logicalid="49" controlid="14" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d6130004c006f006f006b007500700020007400680065002000630075007200720065006e00740020004400650070006100720074006d0065006e0074000d000a0066006f0072002000740068006500200045006d0070006c006f007900650065002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1188" top="8069" logicalid="50" controlid="15" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61440049006600200074006800650020004400650070006100720074006d0065006e00740020006900730020004e0055004c004c002c0020007200650070006c006100630065000d000a00740068006500200063006f006c0075006d006e0020007700690074006800200027004e006f0020004400650070006100720074006d0065006e00740027002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1161" top="10292" logicalid="51" controlid="16" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d6145004c006f006f006b0075007000200074006800650020006c006100740065007300740020005000610079004600720065007100750065006e00630079000d000a0061006e0064002000420061007300650052006100740065002000760061006c00750065007300200066006f0072002000740068006500200045006d0070006c006f007900650065002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-1161" top="12515" logicalid="52" controlid="17" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d6136004c006f006f006b007500700020007400680065002000530061006c00650073005400650072007200690074006f00720079004400570020002000640069006d0065006e00730069006f006e000d000a0073007500720072006f00670061007400650020006b00650079002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-10165</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>402</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">424 UsedTableName</dwd:key><dwd:value xsi:type="xsd:string">[dbo].[DimSalesTerritory]</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">226 OverwriteParamsSQLProp</dwd:key><dwd:value xsi:type="xsd:boolean">false</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">424 OverwriteParamsSQLProp</dwd:key><dwd:value xsi:type="xsd:boolean">false</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">362 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">424 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">362 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">226 UsedTableName</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">226 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">362 UsedTableName</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">837 SCDMetadata</dwd:key><dwd:value xsi:type="xsd:string"><?xml version="1.0" encoding="utf-16"?>
<SCDWizardMetadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ConnectionID>{48D66ADC-386B-451C-823D-CBAEA6441E50}</ConnectionID>
<TableName>[dbo].[DimEmployee]</TableName>
<InputToColumnsCollection>
<InputColumnToDBColumn>
<LineageID>422</LineageID>
<ColumnName>BaseRate</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>62</LineageID>
<ColumnName>BirthDate</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>257</LineageID>
<ColumnName>DepartmentName</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>68</LineageID>
<ColumnName>EmailAddress</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>35</LineageID>
<ColumnName>EmployeeNationalIDAlternateKey</ColumnName>
<KeyType>BusinessKey</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>44</LineageID>
<ColumnName>FirstName</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>80</LineageID>
<ColumnName>Gender</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>59</LineageID>
<ColumnName>HireDate</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>47</LineageID>
<ColumnName>LastName</ColumnName>
<KeyType>None</KeyType>
<ChangeType>ChangingAttribute</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>65</LineageID>
<ColumnName>LoginID</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>74</LineageID>
<ColumnName>MaritalStatus</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>50</LineageID>
<ColumnName>MiddleName</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>53</LineageID>
<ColumnName>NameStyle</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>38</LineageID>
<ColumnName>ParentEmployeeNationalIDAlternateKey</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>395</LineageID>
<ColumnName>PayFrequency</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>71</LineageID>
<ColumnName>Phone</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>835</LineageID>
<ColumnName>Photo</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>77</LineageID>
<ColumnName>SalariedFlag</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>192</LineageID>
<ColumnName>SalesPersonFlag</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>576</LineageID>
<ColumnName>SalesTerritoryKey</ColumnName>
<KeyType>None</KeyType>
<ChangeType>HistoricalAttribute</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>86</LineageID>
<ColumnName>SickLeaveHours</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>56</LineageID>
<ColumnName>Title</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
<InputColumnToDBColumn>
<LineageID>83</LineageID>
<ColumnName>VacationHours</ColumnName>
<KeyType>None</KeyType>
<ChangeType>None</ChangeType>
</InputColumnToDBColumn>
</InputToColumnsCollection>
<GeneratedComponentsIDs>
<anyType xsi:type="xsd:int">885</anyType>
<anyType xsi:type="xsd:int">895</anyType>
<anyType xsi:type="xsd:int">912</anyType>
<anyType xsi:type="xsd:int">1049</anyType>
<anyType xsi:type="xsd:int">1059</anyType>
<anyType xsi:type="xsd:int">1132</anyType>
</GeneratedComponentsIDs>
<FailFixedAttribute>false</FailFixedAttribute>
<FailChangeAttribute>false</FailChangeAttribute>
<UseStartEndDate>true</UseStartEndDate>
<CurrentIndicatorColumn />
<InferredIndicatorColumn />
<ValueCurrent />
<ValueExpired />
<StartDateColumn>StartDate</StartDateColumn>
<EndDateColumn>EndDate</EndDateColumn>
<DateVariable>System::StartTime</DateVariable>
<EnableInferredSupport>false</EnableInferredSupport>
</SCDWizardMetadata></dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">362 OverwriteParamsSQLProp</dwd:key><dwd:value xsi:type="xsd:boolean">false</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">226 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">424 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}{2AB89FA8-1575-409E-A213-10F886DCF576}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Derived Column Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}-166{022617FF-A56A-4969-86A8-B02BF629A88D}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>Derived Column Output</dwd:SourceName><dwd:DestinationName>Lookup Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}-241{3E7A8EBF-FB3E-425D-9842-CCD6A861CB15}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>Lookup Output</dwd:SourceName><dwd:DestinationName>Derived Column Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}-268{4EFA45B9-88DF-481A-A3D8-17273E021A15}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>Derived Column Output</dwd:SourceName><dwd:DestinationName>Lookup Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}-377{EF5D7879-6B41-47BD-9E7E-7E15E5E3423A}
<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>Lookup Output</dwd:SourceName><dwd:DestinationName>Lookup Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{9330370C-A40F-40E5-A563-F5DC23F78ABC}-439{75DB5AC4-0219-4F04-B792-559D67EF8A5B}00-100011048576308110
01
000-100011048576-110
01Load DimEmployee{9330370C-A40F-40E5-A563-F5DC23F78ABC}Data Flow Task{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}0
SELECT
eph.EmployeeID,
eph.PayFrequency,
eph.Rate BaseRate
FROM
HumanResources.EmployeePayHistory eph
WHERE
RateChangeDate =
(SELECT MAX(eph2.RateChangeDate)
FROM HumanResources.EmployeePayHistory eph2
WHERE eph2.employeeID = eph.employeeID)
0
25
25
<referenceMetadata><referenceColumns><referenceColumn name="EmployeeID" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="PayFrequency" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="BaseRate" dataType="DT_CY" length="0" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata>
#32;
1252
EmployeeID
SELECT
edh.EmployeeID,
d.[Name] DepartmentName
FROM
HumanResources.EmployeeDepartmentHistory edh
JOIN HumanResources.Department d
ON d.DepartmentID = edh.DepartmentID
WHERE
edh.EndDate IS NULL
0
25
25
<referenceMetadata><referenceColumns><referenceColumn name="EmployeeID" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="DepartmentName" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata>
#32;
1252
EmployeeID
select * from [dbo].[DimSalesTerritory]
0
25
25
<referenceMetadata><referenceColumns><referenceColumn name="SalesTerritoryKey" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="SalesTerritoryAlternateKey" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="SalesTerritoryRegion" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/><referenceColumn name="SalesTerritoryCountry" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/><referenceColumn name="SalesTerritoryGroup" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata>
#223;
1252
SalesTerritoryAlternateKey
[ISNULL](#257) ? "No Department" : #257
ISNULL(DepartmentName) ? "No Department" : DepartmentName
0
SELECT
e.EmployeeID,
e.NationalIDNumber EmployeeNationalIDAlternateKey,
mgr.NationalIDNumber ParentEmployeeNationalIDAlternateKey,
sp.TerritoryID,
c.FirstName,
c.LastName,
c.MiddleName,
c.NameStyle,
e.Title,
e.HireDate,
e.BirthDate,
e.LoginID,
c.EmailAddress,
c.Phone,
e.MaritalStatus,
e.SalariedFlag,
e.Gender,
e.VacationHours,
e.SickLeaveHours,
e.Photo
FROM
HumanResources.Employee e
JOIN Person.Contact c
ON c.ContactID = e.ContactID
LEFT JOIN HumanResources.Employee mgr
ON mgr.EmployeeID = e.ManagerID
LEFT JOIN Sales.SalesPerson sp
ON sp.SalesPersonID = e.EmployeeID
1252
false
2
0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110
01Update NULL parent keys{1EC908D3-FBBE-4C22-80A5-C7DBAE47BEBA}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910
02-1Constraint{80702163-FF96-44C3-9ACE-FDD7E016995E}LoadDimEmployee{58F72197-F395-4DEB-B23B-112EA9EBC885}MSDTS.Package.10