3 WIN-KA5FODWD12A\Administrator WIN-KA5FODWD12A 4/21/2009 12:27:50 PM 5 0 -1 0 1 0 15 {79CBA848-5533-4F70-9939-08F090CFF553} 0 0 0 0 0 AdventureWorks2008 {070BD9FA-36E0-4828-919A-E2CFB2B985BC} OLEDB 0 Data Source=WIN-KA5FODWD12A\SQL_2K8;Initial Catalog=AdventureWorks2008;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-Raw File Source-{070BD9FA-36E0-4828-919A-E2CFB2B985BC}WIN-KA5FODWD12A\SQL_2K8.AdventureWorks2008;Auto Translate=False; 10.0.1600.22 0 0 -1 0 0 0 1 1048576 3081 1 0 0 User 0 0 6789 Trash {1D2E5343-B856-4CEF-A95A-6B9FA3C08B64} 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 1 1 > Load Raw File Desination {D6C78F82-3C15-4D86-8443-B631B6D4DC9E} Load Raw File Desination SSIS.Pipeline.2 0 0 [Sales].[SalesOrderDetail] 1252 false 0 0 C:\BIMonkeySamples\rawfile 0 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 > Read Raw File {AB5DCBAD-0B7C-45BA-974C-39CE57A022BD} Read Raw File SSIS.Pipeline.2 0 0 C:\BIMonkeySamples\rawfile 0 C:\BIMonkeySamples\rawfile2 0 0 2 -1 Constraint {AA209303-50F7-4E49-B1A8-C163066B9058} Raw File Components Basics {0E3AC0E7-7215-47B9-8096-17F29871C64A} SSIS.Package.2 0 <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: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.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" 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="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="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Load Raw File Desination" left="1582" top="3937" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="5927" 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="00080000271700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D6C78F82-3C15-4D86-8443-B631B6D4DC9E}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Read Raw File" left="1582" top="6451" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="5927" 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="00080000271700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4146" top="4702" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2249" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AA209303-50F7-4E49-B1A8-C163066B9058}" 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="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4545" y="5101" /> <point x="4545" y="6451" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="1006" logicalid="10" controlid="7" masterid="0" hint1="0" hint2="0" width="11238" height="759" 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="00020000e62b0000f7020000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611a005200610077002000460069006c006500200043006f006d0070006f006e0065006e0074007300200052006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="1958" logicalid="11" controlid="8" masterid="0" hint1="0" hint2="0" width="10762" height="503" 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="000200000a2a0000f70100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="8520" top="4207" logicalid="12" controlid="9" masterid="0" hint1="0" hint2="0" width="11159" height="1500" 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="00020000972b0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61d7005400680065002000660069006c00650020007500730065006400200062007900200074006800650020005200610077002000460069006c006500200073006f0075007200630065002000630061006e0020006f006e006c0079002000620065002000670065006e006500720061007400650064002000620079000d000a0074006800650020005200610077002000460069006c0065002000640065007300740069006e006100740069006f006e002c00200073006f002000770065002000670065006e0065007200610074006500200061002000730061006d0070006c00650020007200610077002000660069006c0065002000660069007200730074002e000d000a000d000a0055006e00740069006c002000740068006900730020007300740065007000200068006100730020006200650065006e002000720075006e002c00200074006800650020007000610063006b0061006700650020006d006100790020007200650070006f00720074002000760061006c00690064006100740069006f006e0020006500720072006f0072007300200066006f00720020007300740065007000200032002e00200000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="2672" logicalid="13" controlid="10" masterid="0" hint1="0" hint2="0" width="17378" height="389" 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="00020000e2430000850100000300640000000500008008000080000000002a0001000000900144420100065461686f6d618100540068006900730020007000610063006b00610067006500200065007800700065006300740073002000740068006500200066006f006c006400650072002000220043003a005c00420049004d006f006e006b0065007900530061006d0070006c00650073005c002200200074006f002000650078006900730074002e00200045006900740068006500720020006300720065006100740065002000740068006500200066006f006c0064006500720020006f00720020006d006f006400690066007900200074006800650020007000610063006b00610067006500200074006f002000670065007400200069007400200074006f00200077006f0072006b00210000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 {0E3AC0E7-7215-47B9-8096-17F29871C64A} {3EDF81E3-AE8B-419A-8090-F3C9AC227832} <PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint> dts-designer-1.0 {AA209303-50F7-4E49-B1A8-C163066B9058} {0F7D4EC2-B6BF-4D7C-8ABE-AB1DB4667E4E} <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: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="17" 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="24950" 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="Extracts data from a raw file." left="2117" top="1561" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="5714" 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="00080000521600008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}/components/1" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="8943" top="1588" logicalid="12" controlid="9" masterid="0" hint1="0" hint2="0" width="9572" height="1500" 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="0002000064250000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d616f00480065007200650020007700650020007200650061006400200074006800650020005200610077002000460069006c00650020006300720065006100740065006400200069006e0020007300740065007000200031002e0020000d000a0054006800650020005200610077002000460069006c006500200063006f006e007400610069006e0073002000740068006500200063006f006c0075006d006e0020006d0065007400610064006100740061002c00200073006f0020006d0061007000700069006e0067002000690073002000730069006d0070006c0065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Loads raw data into a file." left="2117" top="4313" logicalid="13" controlid="10" masterid="0" hint1="0" hint2="0" width="5714" 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="00080000521600008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}/components/49" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4575" top="2326" logicalid="14" controlid="11" masterid="0" hint1="0" hint2="0" width="799" height="2487" 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="{AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}/paths/55" 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="10" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4974" y="2725" /> <point x="4974" y="4313" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="8943" top="4524" logicalid="15" controlid="12" masterid="0" hint1="0" hint2="0" width="8382" height="1500" 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="00020000be200000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61490054006f0020006d0061006b006500200070006500720066006f0072006d0061006e00630065002000740065007300740069006e006700200066006100690072002c00200074006800650020006f0075007400700075007400200067006f0065007300200074006f000d000a00610020005200610077002000460069006c0065002000610073002000770065006c006c002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram></TaskHost> dts-designer-1.0 {AB5DCBAD-0B7C-45BA-974C-39CE57A022BD} {B8A79FBF-3743-415D-9A53-4E7B2DE5FE96} <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>Raw File Source Output</dwd:SourceName><dwd:DestinationName>Raw File Destination Input</dwd:DestinationName></PipelinePath> dts-designer-1.0 {AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}-55 {0FB25474-44E4-4759-B444-6C3407D395ED} <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>27</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.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="23" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1106" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" 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="OLE DB Source" left="27" top="2196" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="4762" 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="000800009a1200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D6C78F82-3C15-4D86-8443-B631B6D4DC9E}/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="Loads raw data into a file." left="27" top="4895" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="4762" 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="000800009a1200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D6C78F82-3C15-4D86-8443-B631B6D4DC9E}/components/26" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="2009" top="2961" logicalid="15" controlid="10" masterid="0" hint1="0" hint2="0" width="799" height="2434" 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="{D6C78F82-3C15-4D86-8443-B631B6D4DC9E}/paths/126" 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="3" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="2408" y="3360" /> <point x="2408" y="4895" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="5931" top="2196" logicalid="20" controlid="15" masterid="0" hint1="0" hint2="0" width="8381" height="997" 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="00020000bd200000e50300000300640000000500008008000080000000002a0001000000900144420100065461686f6d615e005400680069007300200073007400650070002000730069006d0070006c0079002000740061006b0065007300200061006c006c00200072006f00770073002000660072006f006d0020007400680065002000530061006c00650073004f007200640065007200440065007400610069006c0073000d000a007400610062006c006500200061006e00640020006f00750074007000750074007300200069007400200074006f002000610020007200610077002000660069006c00650000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="5931" top="4895" logicalid="21" controlid="16" masterid="0" hint1="0" hint2="0" width="9624" height="785" 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="0002000098250000110300000300640000000500008008000080000000002a0001000000900144420100065461686f6d6178004e006f0074006500200074006800650020005200610077002000460069006c0065002000440065007300740069006e006100740069006f006e00200064006f006500730020006e006f007400200075007300650020006100200043006f006e006e0065006300740069006f006e0020004d0061006e0061006700650072000d000a006200750074002000730069006d0070006c007900200073007000650063006900660069006500730020007400680065002000660069006c00650020006e0061006d0065002000770069007400680069006e002000740068006500200063006f006d0070006f006e0065006e00740000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortLeft>-1106</dwd:PersistedViewPortLeft></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 {D6C78F82-3C15-4D86-8443-B631B6D4DC9E} {CEE3758F-6CEB-4DFC-BC47-97B7172110E3} <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>Raw File Destination Input</dwd:DestinationName></PipelinePath> dts-designer-1.0 {D6C78F82-3C15-4D86-8443-B631B6D4DC9E}-126 {A6E9496C-8FE5-421E-8E32-B9B884BB9C87} <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: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.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" 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="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="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Load Raw File Desination" left="1582" top="3937" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="5927" 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="00080000271700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D6C78F82-3C15-4D86-8443-B631B6D4DC9E}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Read Raw File" left="1582" top="6451" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="5927" 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="00080000271700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AB5DCBAD-0B7C-45BA-974C-39CE57A022BD}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4146" top="4702" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="2249" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AA209303-50F7-4E49-B1A8-C163066B9058}" 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="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4545" y="5101" /> <point x="4545" y="6451" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="1006" logicalid="10" controlid="7" masterid="0" hint1="0" hint2="0" width="11238" height="759" 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="00020000e62b0000f7020000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611a005200610077002000460069006c006500200043006f006d0070006f006e0065006e0074007300200052006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="1958" logicalid="11" controlid="8" masterid="0" hint1="0" hint2="0" width="10762" height="503" 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="000200000a2a0000f70100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="8520" top="4207" logicalid="12" controlid="9" masterid="0" hint1="0" hint2="0" width="11159" height="1500" 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="00020000972b0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61d7005400680065002000660069006c00650020007500730065006400200062007900200074006800650020005200610077002000460069006c006500200073006f0075007200630065002000630061006e0020006f006e006c0079002000620065002000670065006e006500720061007400650064002000620079000d000a0074006800650020005200610077002000460069006c0065002000640065007300740069006e006100740069006f006e002c00200073006f002000770065002000670065006e0065007200610074006500200061002000730061006d0070006c00650020007200610077002000660069006c0065002000660069007200730074002e000d000a000d000a0055006e00740069006c002000740068006900730020007300740065007000200068006100730020006200650065006e002000720075006e002c00200074006800650020007000610063006b0061006700650020006d006100790020007200650070006f00720074002000760061006c00690064006100740069006f006e0020006500720072006f0072007300200066006f00720020007300740065007000200032002e00200000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1529" top="2672" logicalid="13" controlid="10" masterid="0" hint1="0" hint2="0" width="17378" height="389" 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="00020000e2430000850100000300640000000500008008000080000000002a0001000000900144420100065461686f6d618100540068006900730020007000610063006b00610067006500200065007800700065006300740073002000740068006500200066006f006c006400650072002000220043003a005c00420049004d006f006e006b0065007900530061006d0070006c00650073005c002200200074006f002000650078006900730074002e00200045006900740068006500720020006300720065006100740065002000740068006500200066006f006c0064006500720020006f00720020006d006f006400690066007900200074006800650020007000610063006b00610067006500200074006f002000670065007400200069007400200074006f00200077006f0072006b00210000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 package-diagram {94301F5D-7C9C-4E9B-B8FB-B4EE6DBFA4C5}