2James Beresfordwww.bimonkey.com5/19/2009 1:56:48 PM50-101027{D5FD2B17-7384-4A48-8417-5C621C7E1278}0000 0AdventureWorks 2005{301DD6E0-8585-4DBB-9F66-0CED36FDDA8D}OLEDB0Data Source=QSP131;Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False; 0AdventureWorks 2005 ADO{137748A6-C3EB-4C2F-BE6E-FB90913C7585}ADO.NET:System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e0890Data Source=QSP131;Initial Catalog=AdventureWorks;Integrated Security=True; <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:BoundingTop>-93</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="13" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1093" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="30083" y="15531" 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="Creates and populates an in-memory ADO recordset." left="780" top="3003" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{44114179-8b37-47ce-87ba-9097e9dca43e}/components/27" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Executes a custom script." left="780" top="-93" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{44114179-8b37-47ce-87ba-9097e9dca43e}/components/236" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="672" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2831" 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="{44114179-8b37-47ce-87ba-9097e9dca43e}/paths/247" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector sourceid="2" destid="1" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4008" y="1071" /> <point x="4008" y="3003" /> </connector> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>-1093</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram></TaskHost>dts-designer-1.0{44114179-8b37-47ce-87ba-9097e9dca43e}{6260203E-6F7C-4B1B-881B-4E7EA53E9C2F} <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>Output 0</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{44114179-8b37-47ce-87ba-9097e9dca43e}-247{4181F796-A410-4481-A59E-BA1C98ACA40A} <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="14" 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="8467" y="7620" 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="01000000900144420100144d6963726f736f66742053616e73205365726966" /> </font> <mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager><ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Source" left="780" top="3003" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/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="Executes a custom script." left="780" top="6270" logicalid="7" controlid="2" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/components/16" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Creates and populates an in-memory ADO recordset." left="780" top="9538" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/components/27" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="3768" logicalid="9" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="3002" 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="{719D2F4B-C8DA-4266-9F44-726B2935428F}/paths/188" 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="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4008" y="4167" /> <point x="4008" y="6270" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="7035" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="799" height="3003" 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="{719D2F4B-C8DA-4266-9F44-726B2935428F}/paths/189" 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="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4008" y="7434" /> <point x="4008" y="9538" /> </connector> </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{719D2F4B-C8DA-4266-9F44-726B2935428F}{C7939408-2C07-4E2A-AAA2-CFED9315CB6D} <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>Input 0</dwd:DestinationName></PipelinePath>dts-designer-1.0{719D2F4B-C8DA-4266-9F44-726B2935428F}-188{9FB20D3C-B4B3-4BF7-A928-556E1D2A9887} <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>Output 0</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{719D2F4B-C8DA-4266-9F44-726B2935428F}-189{B517BE3E-308A-4098-A244-3BBB8523BC68} <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>979</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="24" 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="30083" y="16457" 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="Validation warnings occurred." left="1000" top="3858" logicalid="11" controlid="1" masterid="0" hint1="0" hint2="0" width="11191" 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="00080000b72b00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1000" top="1000" logicalid="12" controlid="2" masterid="0" hint1="0" hint2="0" width="9757" height="865" 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="000200001d26000061030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611c0053006300720069007000740020005400720061006e00730066006f0072006d006100740069006f006e00200052006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1000" top="1979" logicalid="13" controlid="3" masterid="0" hint1="0" hint2="0" width="10948" height="653" 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="00020000c42a00008d0200000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Add Description" left="1000" top="6157" logicalid="14" controlid="4" masterid="0" hint1="0" hint2="0" width="11191" 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="00080000b72b00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{dca60189-827c-43f7-8fa3-a3e8acc03a01}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Add Description" left="1000" top="7967" logicalid="15" controlid="5" masterid="0" hint1="0" hint2="0" width="11191" 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="00080000b72b00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Add Description" left="1000" top="9777" logicalid="16" controlid="6" masterid="0" hint1="0" hint2="0" width="11191" 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="00080000b72b00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{44114179-8b37-47ce-87ba-9097e9dca43e}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1000" top="3123" logicalid="17" controlid="7" masterid="0" hint1="0" hint2="0" width="6000" height="494" 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="0002000070170000ee0100000300640000000500008000000000000000002a0001000004900144420100065461686f6d61290053006300720069007000740020005400720061006e00730066006f0072006d006100740069006f006e002000610073002000610020005400720061006e00730066006f0072006d006100740069006f006e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1000" top="5583" logicalid="18" controlid="8" masterid="0" hint1="0" hint2="0" width="6000" height="574" 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="00020000701700003e0200000300640000000500008000000000000000002a0001000004900144420100065461686f6d61210053006300720069007000740020005400720061006e00730066006f0072006d006100740069006f006e0020006100730020006100200053006f00750072006300650000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1006" top="11456" logicalid="19" controlid="9" masterid="0" hint1="0" hint2="0" width="6000" height="601" 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="0002000070170000590200000300640000000500008000000000000000002a0001000004900144420100065461686f6d61260053006300720069007000740020005400720061006e00730066006f0072006d006100740069006f006e00200061007300200061002000440065007300740069006e006100740069006f006e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="979" top="12488" logicalid="20" controlid="10" masterid="0" hint1="0" hint2="0" width="11218" 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="00080000d22b00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{AA15E5AE-97FB-4D5D-B081-C68189A4DD3F}{2EA82703-AEA4-49EA-8FCF-1ABC79B43DC3} <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>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="16" 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="30083" y="15531" 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="Executes a custom script." left="2032" top="7218" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="5397" 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="00080000151500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}/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="OLE DB Source" left="2032" top="1635" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="5397" 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="00080000151500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}/components/12" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Creates a sample dataset by extracting a number of rows from a dataset." left="2032" top="4426" logicalid="11" controlid="8" masterid="0" hint1="0" hint2="0" width="5397" 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="00080000151500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}/components/115" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4331" top="2400" logicalid="12" controlid="9" masterid="0" hint1="0" hint2="0" width="799" height="2526" 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="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}/paths/123" 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="8" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4730" y="2799" /> <point x="4730" y="4426" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4331" top="5191" logicalid="13" controlid="10" masterid="0" hint1="0" hint2="0" width="799" height="2527" 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="73.4643734643735" controlid="11" width="3546" height="344" side="0" behavior="2" himetric="1196" distfromline="175" startobj="0" x="1009" y="6534" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}/paths/199" 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="1" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4730" y="5590" /> <point x="4730" y="7218" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1009" top="6534" logicalid="14" controlid="11" masterid="10" hint1="0" hint2="0" width="3546" 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="00020000da0d000058010000030000000000050000800800008001000000250001000000900144420100065461686f6d611800530061006d0070006c0069006e0067002000530065006c006500630074006500640020004f007500740070007500740000000000" /> </control> <layoutobject> <ddsxmlobj> <property name="AnnotationAdornment" 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">12 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">12 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}{7AD7293C-D7BE-4FF2-8AED-25A718167E91} <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>Row Sampling Input 1</dwd:DestinationName></PipelinePath>dts-designer-1.0{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}-123{1B6C630D-4827-4368-BC52-B6B06513BF03} <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>Sampling Selected Output</dwd:SourceName><dwd:DestinationName>Input 0</dwd:DestinationName></PipelinePath>dts-designer-1.0{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}-199{CBA0D152-AAD2-4B6B-A379-441B487A1704} <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="16" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-6000" scrolltop="-1256" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="20055" y="15531" 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="Creates and populates an in-memory ADO recordset." left="0" top="3003" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{dca60189-827c-43f7-8fa3-a3e8acc03a01}/components/27" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Executes a custom script." left="0" top="-256" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{dca60189-827c-43f7-8fa3-a3e8acc03a01}/components/236" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="2829" top="509" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2994" 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="{dca60189-827c-43f7-8fa3-a3e8acc03a01}/paths/247" 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="1" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="3228" y="908" /> <point x="3228" y="3003" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="7408" top="-171" logicalid="8" controlid="4" 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="0002000070170000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d613e005400680069007300200063006f006d0070006f006e0065006e0074002000670065006e00650072006100740065007300200031003000200072006f007700730020007500730069006e0067000d000a0061002000730069006d0070006c006500200066006f0072002d006e0065007800740020006c006f006f00700000000000" /> </control> <layoutobject><ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortLeft>-6000</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-1256</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram></TaskHost>dts-designer-1.0{dca60189-827c-43f7-8fa3-a3e8acc03a01}{0B3D9F16-DAB7-4692-8CCA-248AE609A829} <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>Output 0</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{dca60189-827c-43f7-8fa3-a3e8acc03a01}-247{45528DD9-66B9-4E91-80BF-438746231323} <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="20" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1255" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="31962" y="12039" 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="Creates and populates an in-memory ADO recordset." left="2275" top="3003" logicalid="8" controlid="1" masterid="0" hint1="0" hint2="0" width="3466" 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="000800008a0d00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}/components/27" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Executes a custom script." left="3492" top="-255" logicalid="9" controlid="2" masterid="0" hint1="0" hint2="0" width="6456" 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="00080000381900008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}/components/236" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="510" logicalid="10" controlid="3" masterid="0" hint1="0" hint2="0" width="2411" height="2993" 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="33.2703723691311" controlid="8" width="1528" height="344" side="0" behavior="2" himetric="1233" distfromline="175" startobj="0" x="3731" y="1437" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}/paths/247" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector sourceid="2" destid="1" sourceattachpoint="7" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="5620" y="909" /> <point x="5620" y="1956" /> <point x="4008" y="1956" /> <point x="4008" y="3003" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Creates and populates an in-memory ADO recordset." left="8175" top="3003" logicalid="11" controlid="4" masterid="0" hint1="0" hint2="0" width="3466" 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="000800008a0d00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}/components/306" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="7421" top="510" logicalid="12" controlid="5" masterid="0" hint1="0" hint2="0" width="2887" height="2993" 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="66.9057867049259" controlid="9" width="1701" height="344" side="0" behavior="2" himetric="2798" distfromline="175" startobj="0" x="7790" y="2036" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ecad4c7b-5608-421f-b2bd-28c0a59f9173}/paths/311" 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="15" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="7820" y="909" /> <point x="7820" y="1861" /> <point x="9908" y="1861" /> <point x="9908" y="3003" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="3731" top="1437" logicalid="15" controlid="8" masterid="3" hint1="0" hint2="0" width="1528" 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="00020000f805000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d610a004c006500660074004f007500740070007500740000000000" /> </control> <layoutobject><ddsxmlobj><property name="AnnotationAdornment" value="-1" vartype="11" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="7790" top="2036" logicalid="16" controlid="9" masterid="5" hint1="0" hint2="0" width="1701" 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="00020000a506000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d610b00520069006700680074004f007500740070007500740000000000" /> </control> <layoutobject><ddsxmlobj><property name="AnnotationAdornment" value="-1" vartype="11" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>-1255</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram></TaskHost>dts-designer-1.0{ecad4c7b-5608-421f-b2bd-28c0a59f9173}{724A96A2-1A74-484B-B0D3-DD4D2C23D09C} <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>LeftOutput</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{ecad4c7b-5608-421f-b2bd-28c0a59f9173}-247{434D72DF-0C73-40F0-A17E-9C5C74AC6C46} <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>RightOutput</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{ecad4c7b-5608-421f-b2bd-28c0a59f9173}-311{2613FAAD-85E3-4E00-807A-984919403465}00-100011048576308110 0User002Multiplier{D7657F12-FF70-45F7-819F-E1A78A7F0076} 0User00 Trash{A16E639B-B691-4AB3-B74F-0460DB896762} 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 011 > Script Transformation - Simple Transformation{719D2F4B-C8DA-4266-9F44-726B2935428F}Add DescriptionDTS.Pipeline.10 0 [Sales].[SalesOrderHeader] 1252 false 0 ]]> format Row.DoubleDue = Row.TotalDue * CType(Me.Variables.Multiplier, Decimal) End Sub End Class ]]> ScriptComponent_dccf7c7cef764309bdfb8538d3883ad9 true User::Multiplier Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 User::Trash 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 012b > Script Transformation - Complex Source - Two Outputs{ecad4c7b-5608-421f-b2bd-28c0a59f9173}Add DescriptionDTS.Pipeline.10 User::Trash ]]> ScriptComponent_f068b6e8753545eda2c3c5a7bf290ed7 true Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 User::Trash 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 012c > Script Transformation - Complex Source - Reading in Data{44114179-8b37-47ce-87ba-9097e9dca43e}Add DescriptionDTS.Pipeline.10 User::Trash ]]> ScriptComponent_5936eb6aa9a34a5190f7bebd8b8541d8 true Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 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 012a > Script Transformation - Simple Source{dca60189-827c-43f7-8fa3-a3e8acc03a01}Add DescriptionDTS.Pipeline.10 User::Trash ]]> ScriptComponent_2691e3ad986e407e80c36982a6c2de4f true Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 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 013a > Script Transformation - Simple Destination{CB4F9B66-BA3F-4656-AEB5-493FDBCBBD30}Data Flow TaskDTS.Pipeline.10 0 [Person].[Contact] 1252 false 0 10 0 true 44 47 50 53 56 59 62 65 68 71 74 77 80 83 86 false 44 47 50 53 56 59 62 65 68 71 74 77 80 83 86 ]]> ScriptComponent_b7076fbfe3d14fd6885dd75a4ab5cb82 true Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Script Transformation Basics 2005{AA15E5AE-97FB-4D5D-B081-C68189A4DD3F}MSDTS.Package.10