MZ@ !L!This program cannot be run in DOS mode. $PELsK!   >8 @* ,@7K@pP`` T7  H.textD  `.rsrcp@0@@.reloc `@@B 8Hl0 .P f/ ,pI7QΘy=LP}ϱkH49QV9?j\ ǣX}y$fwRXGژk*Ju{l@F27bQil( *0o ( rpo s s o o &o s }{o o o {o r%po  (o! {o rGpo  (o!  rsp(-`{o" rpo# to$ {o" rpo# to$ {o" rpo# to$  rp( rCp( rkp( rp( rp((%   o& (%   o& (%   o& (%   o& (%   o& {o rpo  r'p(o! {o rIpo o! {o rapo o! {o rypo o! {o rpo o! {o rpo o! ('   rp(( rp()  {o rpo  rp( (* o! r1po+ ,({o r1po  r1p(o! +8{o" rcpo# t<  o, r1po# to$ }*0 {,{(- , (+s. z{o rpo o/ s {{o o0 &{{o o1 }}(2 ,(3 ,o,oz(,s. z*E7|{,{(- , (+s. z{*0o+ - (/s. zt:*0o+ - (/s. zA*0 mrpo4 ,rpo+ t:*rp(rp(r'p(rIp(rqp(rp(( *0 mrpo4 ,rpo+ t:*rp(rp(r7p(rOp(rmp(rp(( *0 s5 rpo6 &rpo7 &,rpo6 &+'r/p( o7 &rIp( o7 &,o8 1repo7 &rp-rp+rpo7 &o9 *Nrp'( (: *0<s;   +  o< o= &3o= & X o8 2o9 *b%{(> t}*b%{(? t}*b%{(> t }*b%{(? t }*r{,{s@ oA *{,{sB oC **>}}*0( } sD }{ryp oE {rp oE {r1p oE {rIp oE {rap oE {rp oE {rp oE {rp oE dsD }*{ **0rrp(F ,d{ PtF oG {oH ,{oI G  X {GoJ { no&R*0 U .K{ -(0s. } {  rpj(0s. o&****0Ru9uoK rp(F ,{ {jo&*rp(F ,{ {jo&*{oL ,%{ {oI rpjo&**0RuH,uHoM rGpoN }u9uoK rp(F ,c{oO u   riprsp($rprp($ - }+ }{ {jo&*rp(F ,{ {jo&*{oL ,%{ {oI rpjo&**:{ o*Z{  rpjo***>{ o*>{ o*0 QoQ &  ,$oR ,rp(S , (&Q+QP-*oQ &  ,$oR , rp(S , (&+,rpP(T Q* @ J0<s;   +  o< o= &3o= & X o8 2o9 *0# (U rp ](%(V *rp*( *(2*(3*.rp(4*.rp(4*6r-p(6*FrIpL(5*2rip(5*nrpLL(7*( *~%*%*F~$~%oX *0' (Y ~$~%oX  (V *0+ (Y ~$~%oX  (V *09 (Y ~$~%oX  (V *(Z o[ (Z o\ o] s^ $%*lSystem.Resources.ResourceReader, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSetPADPADPiYESГ0і0 3 7/22/2003 10:21:00 AM 0 1 -1 0 1 0 350 {284A1186-49CC-41E8-8ABA-85677F505FD9} 0 0 0 0 0 AllowedToFailPrologueSql {BE58AECC-FFF4-4750-B227-F75F04783BD9} FILE 0 0 CompensatingSql {EE2A770D-C880-4BD3-9597-894197E388A9} FILE 0 0 DestinationConnection {2DE2D49B-9016-4B65-9115-CBDF47024C93} OLEDB -1 0 EpilogueSql {62D7C08F-54C3-46BF-887B-4F470DA49D81} FILE 0 0 InnerPackage.dtsx {DC5BE2A1-65B7-4C07-BD7B-0176FB40530F} FILE 0 0 NonTransactableSql {CFCB1EA1-70B7-4857-8530-2D5B87793582} FILE 0 0 PostTransactionSql {252be6d5-6da3-4e54-806b-2fedc652a75e} FILE 0 0 PrologueSql {DC5352A8-33F6-4F91-B607-E2530D2EA710} FILE 0 0 SourceConnection {498EA2DE-886F-46DC-83ED-A589A25BA030} OLEDB -1 0 TableSchema.XML {2C97E31C-09ED-49A7-BF52-5EC5009A6EC2} FILE 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>-22671</dwd:BoundingLeft><dwd:BoundingTop>-5383</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="49" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-9717" scrolltop="-3467" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="102" x="36221" y="19897" 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.DdsContainerObjectManagedBridge.2" tooltip="Foreach Loop Container" left="-15195" top="-104" logicalid="24" controlid="1" masterid="3" hint1="0" hint2="0" width="5349" height="5015" 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="00080000e514000097130000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Foreach Loop Container" vartype="8" /> <property name="CaptionHeight" value="900" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="6720" vartype="3" /> <property name="LogicalObject" value="{2EC1DF0C-5DE5-43FF-ACEB-C6AABBAE9FFB}" vartype="8" /> <property name="RealHeight" value="0" vartype="3" /> <property name="RealWidth" value="0" vartype="3" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute Package Task" left="-14814" top="3016" logicalid="25" controlid="2" masterid="1" hint1="0" hint2="0" width="4604" 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="00080000fc1100008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{54DDBBDD-D0D7-473E-837B-ABABBDD68E47}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.2" tooltip="Sequence Container" left="-16194" top="-5383" logicalid="26" controlid="3" masterid="0" hint1="0" hint2="0" width="6751" height="12521" 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="000800005f1a0000e9300000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Transaction Scoping Sequence" vartype="8" /> <property name="CaptionHeight" value="900" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="11430" vartype="3" /> <property name="LogicalObject" value="{1CE54769-9263-4C02-8B43-6EF00A0F8803}" vartype="8" /> <property name="RealHeight" value="0" vartype="3" /> <property name="RealWidth" value="0" vartype="3" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-22541" top="-187" logicalid="27" controlid="4" masterid="0" hint1="0" hint2="0" width="4736" 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="00080000801200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0EF10899-C3D1-42B3-A403-60D314E36985}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-18204" top="-4" logicalid="28" controlid="5" masterid="0" hint1="0" hint2="0" width="2310" height="1281" 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="{A3519562-ED0F-4569-A4AD-B1E403808290}" 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="4" destid="3" sourceattachpoint="19" destattachpoint="44" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-17805" y="395" /> <point x="-16999" y="395" /> <point x="-16999" y="877" /> <point x="-16194" y="877" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6813" top="5801" logicalid="29" controlid="6" masterid="0" hint1="0" hint2="0" width="5292" 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="00080000ac1400008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{89B63051-F086-4EE5-A13E-8C37B9ED09E9}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6871" top="-2007" logicalid="30" controlid="7" masterid="0" hint1="0" hint2="0" width="5265" 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="00080000911400008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D1B671AA-AF0E-487F-A8C2-4078AA7AB754}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-9842" top="2678" logicalid="31" controlid="8" masterid="0" hint1="0" hint2="0" width="3329" height="4105" 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="255" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{FF387307-2219-4768-B0CC-E5397762C453}" 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="3" destid="6" sourceattachpoint="53" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-9443" y="3077" /> <point x="-8128" y="3077" /> <point x="-8128" y="6383" /> <point x="-6813" y="6383" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-9842" top="-1824" logicalid="32" controlid="9" masterid="0" hint1="0" hint2="0" width="3271" height="901" 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="{E1227293-CBB7-442F-8F41-7F870F140CB3}" 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="3" destid="7" sourceattachpoint="37" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-9443" y="-1323" /> <point x="-8157" y="-1323" /> <point x="-8157" y="-1425" /> <point x="-6871" y="-1425" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-15244" top="-2000" logicalid="33" controlid="10" masterid="3" hint1="0" hint2="0" width="4816" 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="00080000d01200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{EE681273-1CAE-4A0C-BDA1-4BD8C80741D9}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13235" top="-1235" logicalid="34" controlid="11" masterid="0" hint1="0" hint2="0" width="1114" height="1631" 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="{81E39B26-A09C-4146-B35A-6805565AB1E1}" 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="10" destid="1" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12836" y="-836" /> <point x="-12836" y="-470" /> <point x="-12521" y="-470" /> <point x="-12521" y="-104" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-14580" top="5473" logicalid="35" controlid="12" masterid="3" hint1="0" hint2="0" width="3669" 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="00080000550e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{49776B13-54DA-4505-9921-E868B3D4522D}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13145" top="4512" logicalid="36" controlid="13" masterid="0" hint1="0" hint2="0" width="1024" height="1461" 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="{8623112D-8B41-4682-9BB7-1185DAE09206}" 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="12" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12521" y="4911" /> <point x="-12521" y="5192" /> <point x="-12746" y="5192" /> <point x="-12746" y="5473" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-22671" top="-3203" logicalid="37" controlid="14" masterid="0" hint1="0" hint2="0" width="4948" 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="00080000541300008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0D1C5913-2F29-4D8C-90E9-9DF6D9F2FAE1}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-20596" top="-2438" logicalid="38" controlid="15" masterid="0" hint1="0" hint2="0" width="823" height="2751" 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="{C050DFB3-6B78-4C91-AD43-DA2439BD6105}" 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="14" destid="4" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-20197" y="-2039" /> <point x="-20197" y="-1113" /> <point x="-20173" y="-1113" /> <point x="-20173" y="-187" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Transfer Task" left="-13910" top="1021" logicalid="39" controlid="16" masterid="1" hint1="0" hint2="0" width="2750" 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="00080000be0a00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DD953A41-0552-4502-8D68-7E28CA4C3A8B}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-12934" top="1786" logicalid="40" controlid="17" masterid="0" hint1="0" hint2="0" width="822" height="1730" 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="{13EB6A56-0DFB-47E1-813C-D1C76851B1F6}" 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="16" destid="2" sourceattachpoint="5" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12535" y="2185" /> <point x="-12535" y="2600" /> <point x="-12512" y="2600" /> <point x="-12512" y="3016" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6318" top="7884" logicalid="41" controlid="18" masterid="0" hint1="0" hint2="0" width="4307" 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="00080000d31000008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{6577025B-8F37-43CC-8955-F3F91B0660B7}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-4566" top="6566" logicalid="42" controlid="19" masterid="0" hint1="0" hint2="0" width="801" height="1818" 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="16711680" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AF5F34F2-9AD0-4BC4-A9EF-C0D7C3D8DEEE}" 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="6" destid="18" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-4167" y="6965" /> <point x="-4167" y="7424" /> <point x="-4165" y="7424" /> <point x="-4165" y="7884" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-15319" top="-4101" logicalid="43" controlid="20" masterid="3" hint1="0" hint2="0" width="5395" height="1163" 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="00080000131500008b040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{8DB0E71D-C7A1-47A0-8AA5-5CC67CDD1542}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13235" top="-3337" logicalid="44" controlid="21" masterid="0" hint1="0" hint2="0" width="1013" height="1837" 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="16711680" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{4DC1F5CF-AE4F-4DB9-A088-331874EE2440}" 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="20" destid="10" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12622" y="-2938" /> <point x="-12622" y="-2469" /> <point x="-12836" y="-2469" /> <point x="-12836" y="-2000" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6812" top="167" logicalid="45" controlid="22" masterid="0" hint1="0" hint2="0" width="5187" height="1163" 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="00080000431400008b040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{7D05C7EA-E091-4797-ADD9-57F5AD56B50A}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-4638" top="-1242" logicalid="46" controlid="23" masterid="0" hint1="0" hint2="0" width="819" height="1909" 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="{852B4355-AE6A-4C6A-B464-EC08B270C8B7}" 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="7" destid="22" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-4239" y="-843" /> <point x="-4239" y="-338" /> <point x="-4219" y="-338" /> <point x="-4219" y="167" /> </connector> </ddscontrol> </dds></dwd:Layout><dwd:PersistedZoom>102</dwd:PersistedZoom><dwd:PersistedViewPortLeft>-9717</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-3467</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 {0E87A72E-85B8-4B6F-8DD4-70CFADC04DE9} {7B12BD27-FEEE-43F8-88E9-640513BC860B} <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 {13EB6A56-0DFB-47E1-813C-D1C76851B1F6} {E7D5272A-4152-4BAA-8225-C7705180DD4E} <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 {4DC1F5CF-AE4F-4DB9-A088-331874EE2440} {DA881116-1154-4A3F-B5D3-7166B0FFCF6C} <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 {81E39B26-A09C-4146-B35A-6805565AB1E1} {2B0F2583-CC86-497A-849B-4BC6ABA7CAB5} <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 {852B4355-AE6A-4C6A-B464-EC08B270C8B7} {1F9B0AB7-BF18-4E37-BC01-31F7F437D28E} <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 {8623112D-8B41-4682-9BB7-1185DAE09206} {65B5415D-D287-4F08-BA39-59358392F92B} <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 {A3519562-ED0F-4569-A4AD-B1E403808290} {99E99D6F-DB2F-48B3-9848-7063214374DC} <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 {AF5F34F2-9AD0-4BC4-A9EF-C0D7C3D8DEEE} {A71A4827-0283-4413-A712-E78AA52535E9} <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 {C050DFB3-6B78-4C91-AD43-DA2439BD6105} {FCFC2393-D2C5-4A8B-8631-9C526AC7E38B} <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 {E1227293-CBB7-442F-8F41-7F870F140CB3} {214B50FD-19EF-45F0-B3E1-666F1763B20C} <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 {FF387307-2219-4768-B0CC-E5397762C453} {D9D9648E-A722-4C6D-B480-150787B45646} <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>-22671</dwd:BoundingLeft><dwd:BoundingTop>-5383</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="49" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-9717" scrolltop="-3467" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="102" x="36221" y="19897" 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.DdsContainerObjectManagedBridge.2" tooltip="Foreach Loop Container" left="-15195" top="-104" logicalid="24" controlid="1" masterid="3" hint1="0" hint2="0" width="5349" height="5015" 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="00080000e514000097130000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Foreach Loop Container" vartype="8" /> <property name="CaptionHeight" value="900" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="6720" vartype="3" /> <property name="LogicalObject" value="{2EC1DF0C-5DE5-43FF-ACEB-C6AABBAE9FFB}" vartype="8" /> <property name="RealHeight" value="0" vartype="3" /> <property name="RealWidth" value="0" vartype="3" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute Package Task" left="-14814" top="3016" logicalid="25" controlid="2" masterid="1" hint1="0" hint2="0" width="4604" 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="00080000fc1100008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{54DDBBDD-D0D7-473E-837B-ABABBDD68E47}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.2" tooltip="Sequence Container" left="-16194" top="-5383" logicalid="26" controlid="3" masterid="0" hint1="0" hint2="0" width="6751" height="12521" 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="000800005f1a0000e9300000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Transaction Scoping Sequence" vartype="8" /> <property name="CaptionHeight" value="900" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="11430" vartype="3" /> <property name="LogicalObject" value="{1CE54769-9263-4C02-8B43-6EF00A0F8803}" vartype="8" /> <property name="RealHeight" value="0" vartype="3" /> <property name="RealWidth" value="0" vartype="3" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-22541" top="-187" logicalid="27" controlid="4" masterid="0" hint1="0" hint2="0" width="4736" 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="00080000801200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0EF10899-C3D1-42B3-A403-60D314E36985}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-18204" top="-4" logicalid="28" controlid="5" masterid="0" hint1="0" hint2="0" width="2310" height="1281" 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="{A3519562-ED0F-4569-A4AD-B1E403808290}" 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="4" destid="3" sourceattachpoint="19" destattachpoint="44" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-17805" y="395" /> <point x="-16999" y="395" /> <point x="-16999" y="877" /> <point x="-16194" y="877" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6813" top="5801" logicalid="29" controlid="6" masterid="0" hint1="0" hint2="0" width="5292" 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="00080000ac1400008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{89B63051-F086-4EE5-A13E-8C37B9ED09E9}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6871" top="-2007" logicalid="30" controlid="7" masterid="0" hint1="0" hint2="0" width="5265" 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="00080000911400008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{D1B671AA-AF0E-487F-A8C2-4078AA7AB754}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-9842" top="2678" logicalid="31" controlid="8" masterid="0" hint1="0" hint2="0" width="3329" height="4105" 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="255" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{FF387307-2219-4768-B0CC-E5397762C453}" 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="3" destid="6" sourceattachpoint="53" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-9443" y="3077" /> <point x="-8128" y="3077" /> <point x="-8128" y="6383" /> <point x="-6813" y="6383" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-9842" top="-1824" logicalid="32" controlid="9" masterid="0" hint1="0" hint2="0" width="3271" height="901" 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="{E1227293-CBB7-442F-8F41-7F870F140CB3}" 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="3" destid="7" sourceattachpoint="37" destattachpoint="18" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-9443" y="-1323" /> <point x="-8157" y="-1323" /> <point x="-8157" y="-1425" /> <point x="-6871" y="-1425" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-15244" top="-2000" logicalid="33" controlid="10" masterid="3" hint1="0" hint2="0" width="4816" 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="00080000d01200008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{EE681273-1CAE-4A0C-BDA1-4BD8C80741D9}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13235" top="-1235" logicalid="34" controlid="11" masterid="0" hint1="0" hint2="0" width="1114" height="1631" 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="{81E39B26-A09C-4146-B35A-6805565AB1E1}" 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="10" destid="1" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12836" y="-836" /> <point x="-12836" y="-470" /> <point x="-12521" y="-470" /> <point x="-12521" y="-104" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-14580" top="5473" logicalid="35" controlid="12" masterid="3" hint1="0" hint2="0" width="3669" 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="00080000550e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{49776B13-54DA-4505-9921-E868B3D4522D}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13145" top="4512" logicalid="36" controlid="13" masterid="0" hint1="0" hint2="0" width="1024" height="1461" 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="{8623112D-8B41-4682-9BB7-1185DAE09206}" 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="12" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12521" y="4911" /> <point x="-12521" y="5192" /> <point x="-12746" y="5192" /> <point x="-12746" y="5473" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-22671" top="-3203" logicalid="37" controlid="14" masterid="0" hint1="0" hint2="0" width="4948" 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="00080000541300008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0D1C5913-2F29-4D8C-90E9-9DF6D9F2FAE1}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-20596" top="-2438" logicalid="38" controlid="15" masterid="0" hint1="0" hint2="0" width="823" height="2751" 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="{C050DFB3-6B78-4C91-AD43-DA2439BD6105}" 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="14" destid="4" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-20197" y="-2039" /> <point x="-20197" y="-1113" /> <point x="-20173" y="-1113" /> <point x="-20173" y="-187" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Transfer Task" left="-13910" top="1021" logicalid="39" controlid="16" masterid="1" hint1="0" hint2="0" width="2750" 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="00080000be0a00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{DD953A41-0552-4502-8D68-7E28CA4C3A8B}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-12934" top="1786" logicalid="40" controlid="17" masterid="0" hint1="0" hint2="0" width="822" height="1730" 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="{13EB6A56-0DFB-47E1-813C-D1C76851B1F6}" 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="16" destid="2" sourceattachpoint="5" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12535" y="2185" /> <point x="-12535" y="2600" /> <point x="-12512" y="2600" /> <point x="-12512" y="3016" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6318" top="7884" logicalid="41" controlid="18" masterid="0" hint1="0" hint2="0" width="4307" 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="00080000d31000008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{6577025B-8F37-43CC-8955-F3F91B0660B7}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-4566" top="6566" logicalid="42" controlid="19" masterid="0" hint1="0" hint2="0" width="801" height="1818" 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="16711680" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{AF5F34F2-9AD0-4BC4-A9EF-C0D7C3D8DEEE}" 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="6" destid="18" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-4167" y="6965" /> <point x="-4167" y="7424" /> <point x="-4165" y="7424" /> <point x="-4165" y="7884" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-15319" top="-4101" logicalid="43" controlid="20" masterid="3" hint1="0" hint2="0" width="5395" height="1163" 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="00080000131500008b040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{8DB0E71D-C7A1-47A0-8AA5-5CC67CDD1542}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-13235" top="-3337" logicalid="44" controlid="21" masterid="0" hint1="0" hint2="0" width="1013" height="1837" 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="16711680" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{4DC1F5CF-AE4F-4DB9-A088-331874EE2440}" 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="20" destid="10" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-12622" y="-2938" /> <point x="-12622" y="-2469" /> <point x="-12836" y="-2469" /> <point x="-12836" y="-2000" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Execute SQL Task" left="-6812" top="167" logicalid="45" controlid="22" masterid="0" hint1="0" hint2="0" width="5187" height="1163" 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="00080000431400008b040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{7D05C7EA-E091-4797-ADD9-57F5AD56B50A}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-4638" top="-1242" logicalid="46" controlid="23" masterid="0" hint1="0" hint2="0" width="819" height="1909" 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="{852B4355-AE6A-4C6A-B464-EC08B270C8B7}" 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="7" destid="22" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-4239" y="-843" /> <point x="-4239" y="-338" /> <point x="-4219" y="-338" /> <point x="-4219" y="167" /> </connector> </ddscontrol> </dds></dwd:Layout><dwd:PersistedZoom>102</dwd:PersistedZoom><dwd:PersistedViewPortLeft>-9717</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-3467</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 package-diagram {6FB8D41E-1B0B-4DBF-AF10-535E10C3D7B0} 10.0.1417.2 0 0 -1 0 0 0 32767 -1 1033 1 0 0 User 0 0 EpilogueSQL {06CC0117-85F1-4506-B652-70974EDDD664} 0 User 0 0 NonTransactableSQL {7E2531D1-EC30-420C-95EF-454762D16A45} 0 User 0 0 PrologueSQL {9488D175-4434-47E2-9196-8EFBAABD8D8F} 0 1 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 -1 -1 1 -1 -1 1 0 0 1 NonTransactableSql {0D1C5913-2F29-4D8C-90E9-9DF6D9F2FAE1} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 -1 -1 1 -1 -1 1 0 0 1 START TRANSACTION {0EF10899-C3D1-42B3-A403-60D314E36985} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 0 -1 0 0 0 32767 -1 -1 1 0 0 1 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 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 AllowedToFailPrologueSql {8DB0E71D-C7A1-47A0-8AA5-5CC67CDD1542} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 0 -1 1 -1 -1 1 0 0 1 PrologueSql {EE681273-1CAE-4A0C-BDA1-4BD8C80741D9} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 {3EBC94D1-7A16-4178-B830-257F061C4A22} {3EBC94D1-7A16-4178-B830-257F061C4A22} Microsoft.SqlServer.Dts.Runtime.Enumerators.NodeList.ForEachNodeListEnumerator, Microsoft.SqlServer.ForEachNodeListEnumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 1 0 0 -1 0 0 -1 32767 -1 -1 1 0 0 0 0 CurrentTableNode {236C92FD-D151-48A0-A171-FD8493EA7FD9} 0 0 0 EnumeratedValue {3655BCE9-F9B1-4621-A77F-F37E89B9A801} 0 0 0 EnumeratedValue2 {5C9C2967-56D1-45B1-B524-559AC82C3151} 0 1 0 TableTransferGenerator Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 0 -1 1 1048576 -1 1 0 0 1 Transfer Task {DD953A41-0552-4502-8D68-7E28CA4C3A8B} Transfer Task Microsoft.SqlServer.Dts.Tasks.TableTransferGenerator.TableTransferGenerator, Microsoft.SqlServer.TableTransferGeneratorTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 0 0 -1 0 0 -1 32767 -1 -1 1 -1 0 1 Execute Inner Package {54DDBBDD-D0D7-473E-837B-ABABBDD68E47} Execute Package Task {D952C6E4-FC5B-41F9-B16C-C168F8AC5F5B} 0FalseInnerPackage.dtsx 0 2 -1 Constraint {13EB6A56-0DFB-47E1-813C-D1C76851B1F6} Foreach Loop Container {2EC1DF0C-5DE5-43FF-ACEB-C6AABBAE9FFB} Foreach Loop Container STOCK:FOREACHLOOP 0 CurrentTableNode 0 {A32EFE51-6E31-40DD-A668-5D07674F5A3B} {A32EFE51-6E31-40DD-A668-5D07674F5A3B} EnumeratedValue -1 {9E5C2D5C-4120-4546-AFBA-05E2DC268165} {9E5C2D5C-4120-4546-AFBA-05E2DC268165} 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 0 -1 1 -1 -1 1 0 0 1 EpilogueSql {49776B13-54DA-4505-9921-E868B3D4522D} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 2 -1 Constraint {81E39B26-A09C-4146-B35A-6805565AB1E1} 0 2 -1 Constraint1 {8623112D-8B41-4682-9BB7-1185DAE09206} 2 2 -1 Constraint 1 {4DC1F5CF-AE4F-4DB9-A088-331874EE2440} Transaction Scoping Sequence {1CE54769-9263-4C02-8B43-6EF00A0F8803} Sequence Container STOCK:SEQUENCE 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 0 0 1 -1 -1 1 0 0 1 ROLLBACK TRANSACTION {89B63051-F086-4EE5-A13E-8C37B9ED09E9} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 1 0 -1 -1 1 1048576 -1 1 0 0 1 CompensatingSql {6577025B-8F37-43CC-8955-F3F91B0660B7} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 -1 -1 1 -1 -1 1 0 0 1 COMMIT TRANSACTION {D1B671AA-AF0E-487F-A8C2-4078AA7AB754} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1 0 0 -1 0 -1 -1 1 1048576 -1 1 0 0 1 PostTransaction Sql {7D05C7EA-E091-4797-ADD9-57F5AD56B50A} Execute SQL Task Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 0 2 -1 Constraint1 {A3519562-ED0F-4569-A4AD-B1E403808290} 1 2 -1 Constraint2 {FF387307-2219-4768-B0CC-E5397762C453} 0 2 -1 Constraint3 {E1227293-CBB7-442F-8F41-7F870F140CB3} 0 2 -1 Constraint {C050DFB3-6B78-4C91-AD43-DA2439BD6105} 2 2 -1 Constraint 1 {AF5F34F2-9AD0-4BC4-A9EF-C0D7C3D8DEEE} 0 2 -1 Constraint 2 {852B4355-AE6A-4C6A-B464-EC08B270C8B7} ShellPackage {0E87A72E-85B8-4B6F-8DD4-70CFADC04DE9} SSIS.Package.2 0BSJB v2.0.50727l #~ d#Strings #US<)#GUIDL)#BlobW 3O%8r^    cCC  y  C iCVCiCCCCCCCiX % @ Y r X     5  \ I p     # K A l x     C CA Ci A n A y A  A    A  C  C C CX    O(NC * ]6JmJ 'J(1tR\w{08V{V4V4V4V4V {V{V1{VK{Vm{V{V{V{V{V{V{VV"V>{V{V{V5{VD{V{V{y n $$$%)0%0\%7%.7T&H=&[G'lLX' Vq' V' `'&`'Yf'm' (n~(H(z(|)$)+).)3*5*7+9+*;+5B+PB+gE+tF+~M+U,lLY,[-W\-n\&-\--\5-]A-]M-][-_m-`z-a-nf-f-f-g-h-j,.mq.s H P H P H H i p |             8CLmx^eo{(8I[f^eo{^po{    EoNckou~   nnnnnnnn nnn!n)n1n9nInQn n1 Y, YR inqnq y i )ni  1 ) # , )M # ]  a   G  9# M  n ) 2 ": 4A 99` Qn V ] e  n o t !nfA1)nI1qnqt 16qBQq# qU q` Q# i In   Yn ii iy $n*,#074<8A<F@KDVHLPTX\`d'h8 l pFtx|;b.;.C.r. 2.D.#n.+.3.{.SG.[G.c&.kc.sG.{ikG>Mi{!%p-5D-  ')*+ , 2 3    $ PMicrosoft.SqlServer.DtsTransferProvider.dllDtsTransferProviderMicrosoft.SqlServer.Management.DtsDtsTransferEventsAssemblyVersionInfoLocalizedKeysmscorlibSystemObjectMicrosoft.SqlServer.ConnectionInfoMicrosoft.SqlServer.Management.CommonIDataTransferProviderIDisposableMicrosoft.SqlServer.ManagedDTSMicrosoft.SqlServer.Dts.RuntimeIDTSEvents.ctorisConfiguredPackagedtsPackageITransferMetadataProviderConfigureExecuteTransferGetPackageSystem.CollectionsSortedListGetConfigStringGetConfigBoolGetDestinationConnectionStringGetSourceConnectionStringGetOleDbConnStringEscapeOleDbValueEscapeStringDataTransferEventHandlertransferEventHandleradd_TransferEventremove_TransferEventDataTransferProgressEventHandlertransferProgressEventHandleradd_TransferProgressEventremove_TransferProgressEventDataTransferEventTypeOnTransferEventDataTransferProgressEventTypeExceptionOnTransferProgressEventDisposeTransferEventTransferProgressEventVariablem_varEnumValuem_nameDestTableHashtable_taskNameToEventType_destNameToRowsSent_parent_firstExceptionget_ExceptionIDTSBreakpointSiteBreakpointTargetOnBreakpointHitTaskHostOnCustomEventDtsObjectOnErrorExecutableDTSExecStatusOnExecutionStatusChangedOnNMProgressOnPostExecuteOnPostValidateOnPreExecuteOnPreValidateOnProgressOnQueryCancelDtsContainerOnVariableValueChangedOnTaskFailedOnWarningOnInformationSystem.XmlXmlNodeConstructQualifiedBracketedNameMakeSqlBraketVersionStringMajorVersionMinorVersionBuildVersionSPLevelProductVersionStringProductNameStringProductNameBrandingStringProductNameShortcutBrandingStringVersionLocationStringProductVersionLocationStringVersionHelpKeywordPrefixVersionHelpSettingsTokenSetupSupportFolderMaxMaintenanceVersionSqlProductFamilyCodeevalTimeBombValuecurrentReleaseTimeBombValueVersionBIDSHelpNamespaceget_VersionHelpNamespaceVersionHelpNamespaceSystem.GlobalizationCultureInfoget_Cultureset_Cultureget_exceptNotSetupget_exceptTranferFailedFileOpenErrorProgressMessageexceptConfigMissingVarexceptDTSErrorCultureexceptNotSetupexceptTranferFailedSystem.ResourcesResourceManagerresourceManager_cultureGetStringSystem.ReflectionAssemblyInformationalVersionAttributeAssemblyFileVersionAttributeAssemblyVersionAttributeAssemblyTrademarkAttributeAssemblyCopyrightAttributeAssemblyProductAttributeAssemblyCompanyAttributeNeutralResourcesLanguageAttributeAssemblyCultureAttributeAssemblyConfigurationAttributeAssemblyDescriptionAttributeAssemblyTitleAttributeCLSCompliantAttributeSystem.Runtime.InteropServicesComVisibleAttributeSystem.DiagnosticsDebuggableAttributeDebuggingModesSystem.Runtime.CompilerServicesCompilationRelaxationsAttributeRuntimeCompatibilityAttributeMicrosoft.SqlServer.DtsTransferProvidermetadataProviderSaveMetadataAssemblyGetExecutingAssemblySystem.IOStreamGetManifestResourceStreamXmlDocumentXmlTextReaderset_ProhibitDtdXmlReaderXmlNodeTypeMoveToContentLoadXmlElementget_DocumentElementLoadFromXMLGetOptionsConnectionsget_ConnectionsConnectionManagerget_Itemset_ConnectionStringExecutablesget_Executablesset_DisableFileFileStreamFileModeFileAccessOpenCloseGuidNewGuidToStringStringConcatPathCombineSequenceop_EqualityTransferExceptionget_ConnectionStringDTSExecResultVariablesIDTSLoggingValidateExecuteExistsDeletevarListvarNameBooleanContainsserverloginSecureloginpassworddatabaseautoTranslateSystem.TextStringBuilderAppendAppendFormatget_LengthvalueFormatscEscget_CharsDelegateRemoveeventTypemessageDataTransferEventArgsInvoketransferIDprogressexDataTransferProgressEventArgsparentAddpBreakpointSitepBreakpointTargetpTaskEventNameEventTextppsaArgumentssubComponentpbFireAgainMicrosoft.SqlServer.DTSPipelineWrapMicrosoft.SqlServer.Dts.Pipeline.WrapperIDTSBuffer100GetRowCountContainsKeyUInt32set_ItemsourceerrorCodedescriptionhelpFilehelpContextiDOfInterfaceWithErrorpExecnewStatuspTaskHoststrProgressEventnCountDonenCountMaxget_NameForEachLoopget_Variablesget_ValueProgressDescriptionPercentCompleteProgressCountLowProgressCountHighpContainerpVariableinformationCodeidofInterfaceWithErrorfireAgaincolumnNodeDoctagNametagSchemanameTableOutAttributeSelectSingleNodeget_InnerTextop_Inequalityget_InvariantCultureIFormatProviderCompilerGeneratedAttributefilenameiterationCountInt32varnameerrorcodehelpfilehelpcontextidkeyarg0get_CurrentCulturearg1arg2arg3arg4.cctorTypeRuntimeTypeHandleGetTypeFromHandleget_FullNameModuleget_Moduleget_AssemblyMicrosoft.SqlServer.Management.Dts.Localized.resourcesShellPackage.dtsx#ShellPackage.dtsx!SourceConnection+DestinationConnection3UseDestinationTransaction#START TRANSACTION)ROLLBACK TRANSACTION%COMMIT TRANSACTION'PrologueSqlFileName'EpilogueSqlFileName5NonTransactableSqlFileName/CompensatingSqlFileName5PostTransactionSqlFileNameTableSchema.XML!MetadataFileNamePrologueSqlEpilogueSql%NonTransactableSqlCompensatingSql%PostTransactionSqlD .dtsx#InnerPackage.dtsxTempDirName1AllowedToFailPrologueSql9Transaction Scoping Sequence7DestinationConnectionString#DestinationServer-DestinationLoginSecure!DestinationLogin'DestinationPassword'DestinationDatabase1DestinationTranslateChar-SourceConnectionStringSourceServer#SourceLoginSecureSourceLoginSourcePasswordSourceDatabase'SourceTranslateChar%Provider=SQLNCLI10!;Data Source={0}3;Integrated Security=SSPI;User ID={0};Password={0});Initial Catalog={0}%;AutoTranslate={0} False True '{0}'%OnPipelineRowsSentTransfer Task+Execute Inner Package!CurrentTableNode Name SchemaDestNameDestSchema. [{0}]-ms-help://MS.SQLCC.v10exceptNotSetup'exceptTranferFailedFileOpenErrorProgressMessage-exceptConfigMissingVarexceptDTSErrorzDދAnz\az\V4]̀̑        ! !% % ) - 15 91 1 =A E I MQ E M E  U5 E I I Y(110.0.0.0 2@ 10.50(Microsoft SQL Server8Microsoft SQL Server 2008 R21001050 sql1052SQLServerBooksOnline.10.0SQLServer2008R211.0.0.0L{20E42995-BBE9-4697-8394-FCDC4338706B} *ms-help://MS.VSCC.v90]]]FileOpenErrorProgressMessageexceptNotSetup&exceptTranferFailed,exceptConfigMissingVarexceptDTSErrora]     $$RSA1''6n_1:fl/y2}/R4H<=\]Ǽ(k,Q\$+Au2IRmRo{l؂O1 ˢ#V{-Pb왹J|};(      Y     M   II                     - 1      5 Y Y YY ) ]59 =   10.50.1600.1)$10.50.1600.1 ((KJ_RTM).100402-1539 )MHMicrosoft SQL Server is a registered trademark of Microsoft Corporation.)$Microsoft Corp. All rights reserved.Microsoft SQL ServerMicrosoft Corporation en-US<7SQL Server Integration Services Table Transfer ProviderTWrapNonExceptionThrowssKDp7p'RSDSDNEuMicrosoft.SqlServer.DtsTransferProvider.pdb8.8 8_CorDllMainmscoree.dll% *0HX@4VS_VERSION_INFO2 @2 @?DVarFileInfo$TranslationxStringFileInfoT000004b0LCompanyNameMicrosoft Corporation8FileDescriptionSQL Server Integration Services Table Transfer Providerl%FileVersion10.50.1600.1 ((KJ_RTM).100402-1539 )x,InternalNameMicrosoft.SqlServer.DtsTransferProvider.dllp%LegalCopyrightMicrosoft Corp. All rights reserved.ILegalTrademarksMicrosoft SQL Server is a registered trademark of Microsoft Corporation.,OriginalFilenameMicrosoft.SqlServer.DtsTransferProvider.dllLProductNameMicrosoft SQL Server@ ProductVersion10.50.1600.1< Assembly Version10.0.0.00 @8`0S *H D0@1 0 +0h +7Z0X03 +70% <<<Obsolete>>>0!0 +(X8C@!Gq)10`0L .P\0 +0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 070822223102Z 120825070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0"0  *H 0 y}]E941%5IwEqFԌkLRbMIl/$>e# HuEP%+ #A$bEJͳ/"J-|o;99ݽ)f;-2'Hlc\򸔣8P'N0==l9.4. }bxfs Oc,2EJ;PSfQyV>Pn5{$Rf=N+~3nGўJnS00U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0U00Uvp[NQD.Dc0 U0 +{~J&μNtX't*uLxMi|CʇSŸVocDDȚ  )}s9=j8m҈#i 4|.)Bk(q8 ]hͽAkf4|zB{ p֒O8|-=4 b7j#\cZ9`U3; _,˫ 0  *RA^0(ip΀Brv0z0b a>0  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0 091207224029Z 110307224029Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1 0 U MOPR10UMicrosoft Corporation0"0  *H 0 0ErSkO#=Y@8s&S<B8auM\F^i[s)DdY/]nǫ9eħuꇗ&&v89&+ZT!򗍇)I,?}͖ q B5׸?ݎE }K[vrw#}5]PKGmUTN؁B1U SI0奈|^zZ7i2$00U% 0 +0U8xs2_Uƙt0U0U#0vp[NQD.Dc0DU=0;09753http://crl.microsoft.com/pki/crl/products/CSPCA.crl0H+<0:08+0,http://www.microsoft.com/pki/certs/CSPCA.crt0  *H ( oBvCB$e4uq0r7:pQ q(ps{V4ZrN {DO aun+Z 9`jT;1_,nM*v{Ƈֱ*rTn*ȞobKk=/zw9gj{cI&Bޕ" _s2r6)$ROfH&9iPNl.r!m$H@|t8JO00j O%EXzg0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 060916010447Z 190915070000Z0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0"0  *H 0 7nBJqH>S,2ORȃ>3I1(dPKuǨծipfx'f趷 Y")/@VvmdmJT޿ǀL7VhGv\/}%V[jc|<%M9wt]\؆7,u9 |vlnz>q_*Ob`2҃N+"\hE/Pl%ׅvs6ƕz`3[AXn,HoCj&k(0$0U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0 +70UoN?4K;AC0 +7  SubCA0 U0U00  *H M1|PapEsT? -QS9V ތ;ɷQ!oi~k"Flm|"Fӄ6~p]Eݎ*|ɮ2Շc6!v;s!شTeJ(&`;exHϭ:ObX099!dcC/{FeJtn ̝(a|H!8Ŗ2@S=f7"̰wTQ:rD#00 a00  *H 0y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA0 080725190115Z 130725191115Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:85D3-305C-5BCF1%0#UMicrosoft Time-Stamp Service0"0  *H 0 -g%&bK08e46$h{b,FKQ4lZ;G=.5kE<fiJ',gbT'9هN`G#{'@ 15 ӋxaŵA>6X':ڽ]L0 +0 *H  1  +70 +7 10  +70# *H  1y>rݹT80X +7 1J0H&$SQL Server 2008 R2http://www.microsoft.com/sql0  *H  \f\3בE\.&.ENO;K\DX ?7s_c7bY= R73+dgtioZB~Г 1Yh6v~?&hc\WφAo3v@g*#h=]]'5>z< Ybz˻e5-s?CSi0ؐJNr7os|(v3YQWځXh0 *H  1 000y1 0 UUS10U Washington10URedmond10U Microsoft Corporation1#0!UMicrosoft Timestamping PCA a00+]0 *H  1  *H 0 *H  1 100403180305Z0# *H  18ݠKw?[ N0  *H mWGz@E}n[b`%:pЃɈb;&5 Z|' y %x'!q0%'ΐ{Po#5CٮzK/UK7#è}#C ("S(8!Z5;( R@|IDf{)&KuUQ?yBwr'cu?OhokCN˘O%UjH(@Z&076wzT,DuX