3
LAPTOP\BIMonkey
LAPTOP
4/2/2009 12:11:53 PM
5
0
-1
0
1
0
24
{65CF683D-5FAF-46C0-9B6B-269F9EE368ED}
0
0
0
0
0
AdventureWorks2008
{60206A01-2CE5-47F3-BCD8-BF9752C88BF8}
Update this to connect to your own SQL Server Instance of teh AdventureWorks2008 Database
OLEDB
0
Data Source=WIN-KA5FODWD12A\SQL_2K8;Initial Catalog=AdventureWorks2008;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-Package-{60206A01-2CE5-47F3-BCD8-BF9752C88BF8}LocalHost.AdventureWorks2008;
10.0.1600.22
0
0
-1
0
0
0
1
1048576
3081
1
0
0
User
0
0
2345SELECT * FROM [HumanResources].[Employee]
SQLCommandVariable
{DDDEBB90-DCE1-4F1E-AD67-74E4F9AF2973}
0
User
0
0
2345[HumanResources].[Employee]
TableNameVariable
{04ACC349-47AC-48B4-B05B-8B6575599282}
0
User
0
0
6789
Trash
{47E428AF-4833-4117-B3EB-14E1DAAB1403}
0
1
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
User
0
0
6789
Trash
{df9c340a-d787-4654-9b43-871567c9fd4e}
0
1
4 > Data Access Mode - SQL Command from Variable
{04394fb6-d46e-40c3-938c-de1e8a4623a6}
Using Data Access Mode - SQL Command from Variable
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
User::SQLCommandVariable
1252
false
3
User::Trash
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
User
0
0
6789
Trash
{05fb1a34-65cf-4fb8-b5a4-35de7f88f867}
0
1
5 > Column Selection
{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}
Showing Column Selection
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
1252
false
0
User::Trash
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
2 > Data Access Mode - Table name or View name variable
{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}
Using Data Access Mode - Table name or View name variable
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
User::TableNameVariable
1252
false
1
User::Trash
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
3 > Data Access Mode - SQL Command
{7248428a-d28b-4c4e-9b87-a97b4c25db85}
Using Data Access Mode - SQL Command
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
SELECT * FROM [HumanResources].[Employee]
1252
false
2
User::Trash
0
Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1
0
0
-1
0
0
0
1
1048576
-1
1
0
0
User
0
0
6789
Trash
{0E7428BE-C9E2-417B-A0B4-589B255BDFBF}
0
1
1 > Data Access Mode - Table or View
{FBC6D5FA-19B3-4A44-A043-026796A601A5}
Using Data Access Mode - Table or View
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
1252
false
0
User::Trash
OLEDB Source Component Basics
{55C5CFD8-3453-43D8-BAC2-B1859F7827CC}
OLE DB Source Component Review
SSIS.Package.2
0
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>3670</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="11" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="2717" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="27067" y="10425" 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.2" tooltip="Showing Column Selection" left="2805" top="7885" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="5688" 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="00080000381600008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="2805" top="10610" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="5688" 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="00080000381600008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}/components/64" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="5250" top="8650" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2460" 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="{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}/paths/67" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="5649" y="9049" />
<point x="5649" y="10610" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2725" top="3670" logicalid="10" controlid="7" masterid="0" hint1="0" hint2="0" width="12244" height="3062" 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="00020000d42f0000f60b00000300640000000500008008000080000000002a0001000000900144420100065461686f6d61370254006800650020004400610074006100200041006300630065007300730020004d006f00640065002000750073006500640020006800650072006500200069007300200022005400610062006c00650020006f0072002000560069006500770022000d000a000d000a00540068006900730020006900730020007400680065002000730069006d0070006c0065007300740020006d006500740068006f00640020006f0066002000650078007400720061006300740069006e006700200064006100740061002000660072006f006d00200061002000640061007400610062006100730065002c00200061006e00640020006900730020006500710075006900760061006c0065006e00740020000d000a0074006f00200061002000530045004c0045004300540020002a002000460052004f004d0020005b005400610062006c00650020006f007200200056006900650077005d002e0020004500760065006e00200069006600200079006f007500200064006f0020006e006f0074002000730065006c00650063007400200061006c006c00200063006f006c0075006d006e007300200069006e00200074006800650020000d000a004f004c004500200044004200200053006f007500720063006500200063006f006d0070006f006e0065006e00740073002000220043006f006c0075006d006e007300220020007400610062002c002000740068006500200063006f006d0070006f006e0065006e00740020007300740069006c006c002000730065006e00640073002000610020002700530045004c0045004300540020002a00270020000d000a0074006f002000740068006500200064006100740061006200610073006500200065006e00670069006e0065002e00200059006f0075002000630061006e0020007600650072006900660079002000740068006900730020007500730069006e0067002000740068006900730020004400610074006100200046006c006f0077002000620065006c006f0077002e0020005300650076006500720061006c00200063006f006c0075006d006e0073000d000a00610072006500200064006500730065006c00650063007400650064002c002000620075007400200069006600200079006f00750020006c006f006f006b00200061007400200077006800610074002000690073002000730065006e007400200074006f00200074006800650020006400610074006100620061007300650020007500730069006e0067002000530051004c002000500072006f00660069006c0065007200200079006f0075002000770069006c006c0020000d000a006e006f007400650020007400680065002000710075006500720079002000690073002000610020002700530045004c0045004300540020002a0027002e00200043006f006e00730065007100750065006e0074006c0079002000740068006900730020006900730020006e006f0074002000610020007600650072007900200065006600660069006300690065006e007400200061007000700072006f006100630068002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>2717</dwd:PersistedViewPortTop></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
{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}
{4B5E6B0F-7BBC-45C2-A99C-4DFFAC4430CC}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}-67
{8EA90798-D92E-4660-AED4-F9A4AA527C5B}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>-113</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1113" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="17886" y="10425" 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.2" tooltip="Using Data Access Mode - SQL Command from Variable" left="2302" top="1825" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="9101" 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="000800008d2300008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{04394fb6-d46e-40c3-938c-de1e8a4623a6}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="2302" top="3967" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="9101" 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="000800008d2300008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{04394fb6-d46e-40c3-938c-de1e8a4623a6}/components/64" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="6453" top="2590" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="1877" 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="{04394fb6-d46e-40c3-938c-de1e8a4623a6}/paths/67" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector sourceid="1" destid="2" sourceattachpoint="17" destattachpoint="16" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="6852" y="2989" />
<point x="6852" y="3967" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2355" top="-113" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="10974" height="1817" 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="00020000de2a0000190700000300640000000500008008000080000000002a0001000000900144420100065461686f6d61c80054006800650020004400610074006100200041006300630065007300730020004d006f0064006500200075007300650064002000680065007200650020006900730020002200530051004c00200043006f006d006d0061006e0064002000660072006f006d0020005600610072006900610062006c00650022000d000a000d000a005400680069007300200061007000700072006f00610063006800200061006c006c006f00770073002000740068006500200075007300650020006f006600200061002000530051004c002000730074006100740065006d0065006e0074002000680065006c006400200069006e002000610020007600610072006900610062006c0065002e00200054006800690073002000630061006e000d000a00620065002000750073006500660075006c0020007700680065006e00200079006f00750020006e00650065006400200074006f00200063006f006e00730074007200750063007400200071007500650072006900650073002000640079006e0061006d006900630061006c006c0079002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>-1113</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{04394fb6-d46e-40c3-938c-de1e8a4623a6}
{E1F12FE0-2AB2-4E8C-BDA0-FA6EAF076864}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{04394fb6-d46e-40c3-938c-de1e8a4623a6}-67
{BA5CC7C2-5879-4E35-95A0-837664782FAD}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingTop>-6932</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="20" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-7952" scrolltop="-7932" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" 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="1" 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.2" tooltip="Using Data Access Mode - Table or View" left="264" top="-4471" logicalid="9" controlid="1" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{FBC6D5FA-19B3-4A44-A043-026796A601A5}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - Table name or View name variable" left="264" top="-2384" logicalid="10" controlid="2" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - SQL Command" left="264" top="-297" logicalid="11" controlid="3" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{7248428a-d28b-4c4e-9b87-a97b4c25db85}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - SQL Command from Variable" left="264" top="1790" logicalid="12" controlid="4" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{04394fb6-d46e-40c3-938c-de1e8a4623a6}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="53" top="-6932" logicalid="13" controlid="5" masterid="0" hint1="0" hint2="0" width="11344" height="839" 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="00020000502c000047030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611e004f004c004500200044004200200053006f007500720063006500200043006f006d0070006f006e0065006e007400200052006500760069006500770000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="0" top="-6218" logicalid="14" controlid="6" masterid="0" hint1="0" hint2="0" width="10525" height="442" 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="000200001d290000ba0100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="26" top="-5656" logicalid="15" controlid="7" masterid="0" hint1="0" hint2="0" width="16372" 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="00020000f43f0000610300000300640000000500008008000080000000002a0001000000900144420100065461686f6d619d00540068006900730020007000610063006b0061006700650020006d0061006b0065007300200075007300650020006f00660020005600610072006900610062006c00650073002e00200049006600200079006f0075002000630061006e006e006f0074002000730065006500200074006800650020005600610072006900610062006c0065007300200074006100620020006f006e00200074006800650020006c006500660074002000730069006400650020006f00660020007400680065002000640065007300690067006e00200061007200650061002c0020000d000a006f00700065006e0020006900740020007500730069006e00670020007400680065002000660069006c00650020006d0065006e0075003a002000530053004900530020003e0020005600610072006900610062006c006500730000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Showing Column Selection" left="264" top="3879" logicalid="16" controlid="8" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-7952</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-7932</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
{55C5CFD8-3453-43D8-BAC2-B1859F7827CC}
{F8D0C7BF-652B-4FE0-BCD2-FC57672EEAC7}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>47</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-953" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="17886" y="10425" 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.2" tooltip="Using Data Access Mode - SQL Command" left="2223" top="3016" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="7541" 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="00080000751d00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{7248428a-d28b-4c4e-9b87-a97b4c25db85}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="2223" top="5767" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="7541" 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="00080000751d00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{7248428a-d28b-4c4e-9b87-a97b4c25db85}/components/64" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="5594" top="3781" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2486" 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="{7248428a-d28b-4c4e-9b87-a97b4c25db85}/paths/67" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector sourceid="1" destid="2" sourceattachpoint="13" destattachpoint="12" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="5993" y="4180" />
<point x="5993" y="5767" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2222" top="47" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="15129" height="2320" 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="00020000193b0000100900000300640000000500008008000080000000002a0001000000900144420100065461686f6d61470154006800650020004400610074006100200041006300630065007300730020004d006f0064006500200075007300650064002000680065007200650020006900730020002200530051004c00200043006f006d006d0061006e00640022000d000a000d000a005400680069007300200061007000700072006f00610063006800200061006c006c006f00770073002000740068006500200075007300650020006f006600200061002000530051004c002000730074006100740065006d0065006e0074002000650069007400680065007200200065006e0074006500720065006400200061007300200066007200650065002000740065007800740020000d000a006f007200200063006f006e007300740072007500630074006500640020007500730069006e00670020007400680065002000510075006500720079002000640065007300690067006e00650072002e00200049007400200061006c006c006f0077007300200066006f007200200063006f006c0075006d006e002000730065006c0065006300740069006f006e00200069006e0020007400680065000d000a00710075006500720079002000730065006e007400200074006f0020007400680065002000640061007400610062006100730065002000610073002000770065006c006c0020006100730020006d006f0072006500200063006f006d0070006c00650078002000530051004c002000730074006100740065006d0065006e00740073002000730075006300680020006100730020000d000a00630061006c006c0069006e006700200072006500730075006c00740073006500740073002000660072006f006d002000730074006f007200650064002000700072006f0063006500640075007200650073002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>-953</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{7248428a-d28b-4c4e-9b87-a97b4c25db85}
{7FC45E1F-6844-462D-B02D-68B31A803D63}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{7248428a-d28b-4c4e-9b87-a97b4c25db85}-67
{F6A757AE-C355-4B73-8C70-4588EF634670}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>-405</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1405" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="17886" y="10425" 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.2" tooltip="Data Access Mode - Table name or View name variable" left="2170" top="2195" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="8838" 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="00080000862200008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="2170" top="4549" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="8838" 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="00080000862200008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}/components/64" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="6190" top="2960" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2089" 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="{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}/paths/67" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector sourceid="1" destid="2" sourceattachpoint="15" destattachpoint="14" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="6589" y="3359" />
<point x="6589" y="4549" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2091" top="-299" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="12007" height="1976" 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="00020000e72e0000b80700000300640000000500008008000080000000002a0001000000900144420100065461686f6d61140154006800650020004400610074006100200041006300630065007300730020004d006f00640065002000750073006500640020006800650072006500200069007300200022005400610062006c00650020006f0072002000560069006500770020006e0061006d00650020007600610072006900610062006c00650022000d000a000d000a0054006800650020006d006f00640065002000660075006e006300740069006f006e00730020007400680065002000730061006d006500200061007300200022005400610062006c00650020006f00720020005600690065007700220020006100630063006500730073002c0020006500780063006500700074002000690074002000740061006b0065007300200074006800650020007400610062006c00650020000d000a006f0072002000760069006500770020006e0061006d0065002000660072006f006d002000610020005600610072006900610062006c0065002e002000490074002000630061006e002000620065002000750073006500660075006c00200069006600200079006f00750020006e00650065006400200074006f0020006c006f006f00700020007400680072006f0075006700680020007300650076006500720061006c000d000a005400610062006c006500730020006f0072002000560069006500770073002000770069007400680020006900640065006e0074006900630061006c00200073007400720075006300740075007200650073002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>-1405</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}
{719248C5-3272-4B82-8C24-B743DE474AA9}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}-67
{E3769260-0707-4892-8E0F-C79D3DDC7064}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>-423</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1423" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="17886" y="10425" 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.2" tooltip="Data Access Mode - Table or View" left="2091" top="1667" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="7514" 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="000800005a1d00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{FBC6D5FA-19B3-4A44-A043-026796A601A5}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="2091" top="3969" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="7514" 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="000800005a1d00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{FBC6D5FA-19B3-4A44-A043-026796A601A5}/components/64" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="5449" top="2432" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2037" 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="{FBC6D5FA-19B3-4A44-A043-026796A601A5}/paths/67" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="13" destattachpoint="12" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="5848" y="2831" />
<point x="5848" y="3969" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2090" top="-423" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="13540" height="1818" 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="00020000e43400001a0700000300640000000500008008000080000000002a0001000000900144420100065461686f6d61ac0054006800650020004400610074006100200041006300630065007300730020004d006f00640065002000750073006500640020006800650072006500200069007300200022005400610062006c00650020006f0072002000560069006500770022000d000a000d000a00540068006900730020006900730020007400680065002000730069006d0070006c0065007300740020006d006500740068006f00640020006f0066002000650078007400720061006300740069006e006700200064006100740061002000660072006f006d00200061002000640061007400610062006100730065002c00200061006e00640020006900730020006500710075006900760061006c0065006e00740020000d000a0074006f00200061002000530045004c0045004300540020002a002000460052004f004d0020005b005400610062006c00650020006f007200200056006900650077005d002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>-1423</dwd:PersistedViewPortTop></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
{FBC6D5FA-19B3-4A44-A043-026796A601A5}
{B3EDC4BA-D61A-45EA-9AE9-97572708CD60}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{FBC6D5FA-19B3-4A44-A043-026796A601A5}-67
{9E987D45-31E2-4B8D-B4E5-0FE7D2EFC0B7}
<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:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingTop>-6932</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="20" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-7952" scrolltop="-7932" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" 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="1" 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.2" tooltip="Using Data Access Mode - Table or View" left="264" top="-4471" logicalid="9" controlid="1" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{FBC6D5FA-19B3-4A44-A043-026796A601A5}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - Table name or View name variable" left="264" top="-2384" logicalid="10" controlid="2" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{9f2833d6-ed1c-4cfd-8cfd-5f28b72320fb}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - SQL Command" left="264" top="-297" logicalid="11" controlid="3" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{7248428a-d28b-4c4e-9b87-a97b4c25db85}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Using Data Access Mode - SQL Command from Variable" left="264" top="1790" logicalid="12" controlid="4" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{04394fb6-d46e-40c3-938c-de1e8a4623a6}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="53" top="-6932" logicalid="13" controlid="5" masterid="0" hint1="0" hint2="0" width="11344" height="839" 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="00020000502c000047030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611e004f004c004500200044004200200053006f007500720063006500200043006f006d0070006f006e0065006e007400200052006500760069006500770000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="0" top="-6218" logicalid="14" controlid="6" masterid="0" hint1="0" hint2="0" width="10525" height="442" 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="000200001d290000ba0100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="26" top="-5656" logicalid="15" controlid="7" masterid="0" hint1="0" hint2="0" width="16372" 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="00020000f43f0000610300000300640000000500008008000080000000002a0001000000900144420100065461686f6d619d00540068006900730020007000610063006b0061006700650020006d0061006b0065007300200075007300650020006f00660020005600610072006900610062006c00650073002e00200049006600200079006f0075002000630061006e006e006f0074002000730065006500200074006800650020005600610072006900610062006c0065007300200074006100620020006f006e00200074006800650020006c006500660074002000730069006400650020006f00660020007400680065002000640065007300690067006e00200061007200650061002c0020000d000a006f00700065006e0020006900740020007500730069006e00670020007400680065002000660069006c00650020006d0065006e0075003a002000530053004900530020003e0020005600610072006900610062006c006500730000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Showing Column Selection" left="264" top="3879" logicalid="16" controlid="8" masterid="0" hint1="0" hint2="0" width="10212" 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="00080000e42700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{025e043f-a6ac-4c7b-99a8-eee3ab2ab150}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-7952</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-7932</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
package-diagram
{2A1CAABF-1754-46E0-9C5B-A73D59C49629}