2James BeresfordQSP1315/20/2009 9:17:24 AM51-101011{399D00CF-CF7D-4D76-B8FE-EDACE541A8BA}0000 -1AdventureWorks 2005{63B19BF7-449C-45C1-BD6C-2E0CB4EF95D5}Note Delay Validation is ste to True for this connectionOLEDB0Data Source=WIN-KA5FODWD12A\SQL_2K5;Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False; <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: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="26" 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="28575" y="11880" 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="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 connecting to AdventureWorks SalesOrderHeader" left="5318" top="1900" logicalid="10" controlid="1" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/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="Aggregates and groups values in a dataset." left="5318" top="4255" logicalid="11" controlid="2" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/components/124" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Trash Destination" left="847" top="8617" logicalid="12" controlid="3" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/components/112" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="7988" top="2665" logicalid="13" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="2090" 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="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/paths/134" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector sourceid="1" destid="2" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="8387" y="3064" /> <point x="8387" y="4255" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Trash Destination" left="10107" top="8617" logicalid="14" controlid="5" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/components/215" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3517" top="5020" logicalid="15" controlid="6" masterid="0" hint1="0" hint2="0" width="4170" height="4097" 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="38.6207946414979" controlid="13" width="2912" height="344" side="0" behavior="2" himetric="2537" distfromline="175" startobj="0" x="3262" y="6499" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/paths/221" 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="3" sourceattachpoint="7" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="7287" y="5419" /> <point x="7287" y="7018" /> <point x="3916" y="7018" /> <point x="3916" y="8617" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="9088" top="5020" logicalid="17" controlid="8" masterid="0" hint1="0" hint2="0" width="4488" height="4097" 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="64.2369682009583" controlid="12" width="2249" height="344" side="0" behavior="2" himetric="4424" distfromline="175" startobj="0" x="9888" y="7193" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}/paths/222" 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="5" sourceattachpoint="15" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="9487" y="5419" /> <point x="9487" y="7018" /> <point x="13176" y="7018" /> <point x="13176" y="8617" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="9888" top="7193" logicalid="21" controlid="12" masterid="8" hint1="0" hint2="0" width="2249" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000c908000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d610e005300740061007400750073002000530075006d006d0061007200790000000000" /> </control> <layoutobject> <ddsxmlobj> <property name="AnnotationAdornment" value="-1" vartype="11" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="3262" top="6499" logicalid="22" controlid="13" masterid="6" hint1="0" hint2="0" width="2912" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000600b000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d6112004f007200640065007200200044006100740065002000530075006d006d0061007200790000000000" /> </control> <layoutobject> <ddsxmlobj> <property name="AnnotationAdornment" value="-1" vartype="11" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram></TaskHost>dts-designer-1.0{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}{F4C74AA1-1370-4C72-B39C-6D6F53A05BFA} <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>Aggregate Input 1</dwd:DestinationName></PipelinePath>dts-designer-1.0{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}-134{07E4D52F-C643-4243-BB71-9A2D1EC35709} <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>Order Date Summary</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}-221{9EB09BF1-A1E1-47EC-ADA9-2E099730A034} <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>Status Summary</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}-222{6F1B352C-6E29-42D6-A0C0-54C0F4812707} <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="28575" y="12806" 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="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="1720" top="4127" logicalid="3" controlid="1" masterid="0" hint1="0" hint2="0" width="8625" 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="00080000b12100008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DC739B41-669A-4E4F-81C5-844D3659B8F4}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="1720" top="6823" logicalid="4" controlid="2" masterid="0" hint1="0" hint2="0" width="8625" 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="00080000b12100008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1720" top="1164" logicalid="8" controlid="6" masterid="0" hint1="0" hint2="0" width="10736" height="786" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000f029000012030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611f0041006700670072006500670061007400650020005400720061006e00730066006f0072006d006100740069006f006e00200072006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1720" top="2117" logicalid="9" controlid="7" masterid="0" hint1="0" hint2="0" width="8751" height="680" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000200002f220000a80200000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f004300720065006100740065006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0020006200790020004a0061006d006500730020004200650072006500730066006f007200640000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{8BF3C3AC-2E0A-4B76-8BC0-56AA69721794}{E6F79EB2-44C4-4AE4-8B9B-9E6ECB7CEF52} <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: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="26" 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="31327" y="11351" 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="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Source connecting to AdventureWorks SalesOrderHeader" left="1085" top="1721" logicalid="8" controlid="1" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DC739B41-669A-4E4F-81C5-844D3659B8F4}/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="Trash Destination" left="1085" top="6431" logicalid="9" controlid="2" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DC739B41-669A-4E4F-81C5-844D3659B8F4}/components/112" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Aggregates and groups values in a dataset." left="1085" top="4076" logicalid="10" controlid="3" masterid="0" hint1="0" hint2="0" width="6138" 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="00080000fa1700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DC739B41-669A-4E4F-81C5-844D3659B8F4}/components/124" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3755" top="2486" logicalid="11" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="2090" 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="{DC739B41-669A-4E4F-81C5-844D3659B8F4}/paths/134" 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="3" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4154" y="2885" /> <point x="4154" y="4076" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3755" top="4841" logicalid="12" controlid="5" masterid="0" hint1="0" hint2="0" width="799" height="2090" 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="50" controlid="16" width="423" height="423" side="1" behavior="2" himetric="595" distfromline="175" startobj="0" x="4329" y="5623" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DC739B41-669A-4E4F-81C5-844D3659B8F4}/paths/162" 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="3" destid="2" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4154" y="5240" /> <point x="4154" y="6431" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="8651" top="4076" logicalid="14" controlid="7" masterid="0" hint1="0" hint2="0" width="6688" height="1341" 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="00020000201a00003d0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d616a00540068006900730020006100670067007200650067006100740069006f006e00200075007300650073002000740068006500200043006f0075006e0074002000660075006e006300740069006f006e00200061006e00640020000d000a00530075006d007300200061006e0064002000410076006500720061006700650073002000740068006500200054006100780041006d00740020006600690065006c0064002c0020000d000a00670072006f007500700069006e00670020006200790020004f007200640065007200440061007400650000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" left="4329" top="5623" logicalid="23" controlid="16" masterid="5" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="1" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" /> </control> <layoutobject> <ddsxmlobj> <property name="VisualizerAdornment" value="-1" vartype="11" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{DC739B41-669A-4E4F-81C5-844D3659B8F4}{102476A7-B6FD-4EDB-8021-618C3B1AC2C6} <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>Aggregate Input 1</dwd:DestinationName></PipelinePath>dts-designer-1.0{DC739B41-669A-4E4F-81C5-844D3659B8F4}-134{3F848024-5CD7-4797-88F8-34F58B7BD79E} <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>Aggregate Output 1</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{DC739B41-669A-4E4F-81C5-844D3659B8F4}-162{A8B77AE4-412F-4A7B-8A24-21ECAEE16110}00-100011048576308110 01 0Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 0User00 Trash{187734FB-4DA8-4EF2-9A88-E2CCB755218A} 011 > Simple Aggregation Example{DC739B41-669A-4E4F-81C5-844D3659B8F4}Data Flow TaskDTS.Pipeline.10 User::Trash 1 1 25

0 95 4 1 0 38 0 1 0 0 2 1 0 95 5 1 0

0 [Sales].[SalesOrderHeader] 1252 false 0

0Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 0User00 Trash{c62491ef-96eb-4bb6-b7e3-5f88ae4c40f3} 012 > Multiple Aggregation Example{70bb352d-d2b0-43bd-aaf1-7cfc251215ac}Data Flow TaskDTS.Pipeline.10 0 [Sales].[SalesOrderHeader] 1252 false 0

User::Trash 0 0 25

0 95 4 1 0 38 0 1 0 0 2 1 0

0 47 0 1 0 0 2 1 0 95 4 1 0

User::Trash Aggregate Transformation Basics 2005{8BF3C3AC-2E0A-4B76-8BC0-56AA69721794}Sample package demonstrating the Aggregate TransformationMSDTS.Package.10