2DOMAIN01\AdministratorWS046/2/2009 3:07:55 PM51-101051{5127861E-37FD-4AB9-9575-B3F3C3935738}0000 0AdventureWorks{F2B6FC5C-1269-42A5-9ED7-563A319728C7}OLEDB0Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False; 0SMTP Connection Manager{4A0719AC-BC57-4D23-B854-C533D1A1BD0C}SMTP <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{052F3D20-20EE-418A-AC05-55B86AF50A20}{05723C43-E9E9-4E40-B4E2-680551431BA4} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>ExpressionAndConstraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{35DE1011-5AFE-48C5-BFB0-E7A439B50E32}{3AB8C938-25E6-4FFA-8071-CA6F805823CF} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{4763D12B-4D80-4E88-B01B-C21E6FB42973}{C65644E5-366A-46CA-A06E-C315C53181A2} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>ExpressionAndConstraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{82F15544-10CB-4167-993B-2E208FCD8166}{9FA9EA2F-356C-4314-BE45-13921CD0AB3A} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{8DA0F342-F657-4026-97CB-D921BA4D5DDD}{A721C792-FC34-46E7-B9BB-491DA0D7C5F7} <TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingTop>1191</dwd:BoundingTop><dwd:Layout><dds> <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="13" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="25823" y="12621" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Source" left="3837" top="1191" logicalid="4" controlid="4" masterid="0" hint1="0" hint2="0" width="3598" 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="000800000e0e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}/components/1" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Destination" left="3836" top="4498" logicalid="5" controlid="5" masterid="0" hint1="0" hint2="0" width="3598" 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="000800000e0e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}/components/16" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="5236" top="1956" logicalid="6" controlid="6" masterid="0" hint1="0" hint2="0" width="800" height="3042" 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="{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}/paths/165" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="4" destid="5" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="5636" y="2355" /> <point x="5636" y="3426" /> <point x="5635" y="3426" /> <point x="5635" y="4498" /> </connector> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">16 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">16 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">View</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}{A8E2BC0B-C49F-42CF-B2A4-36276EC34C7D} <PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>OLE DB Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}-165{85814E14-1211-4D12-81F7-B455355D443F} <Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingTop>-15029</dwd:BoundingTop><dwd:Layout><dds> <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="65" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-353" scrolltop="-15909" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="25823" y="13547" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="6455" top="-15029" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3572" 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="00080000f40d00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{5654627E-9E1F-41C2-964B-D476ED2AF9EF}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="Sequence Container" left="13322" top="-14871" logicalid="8" controlid="8" masterid="0" hint1="0" hint2="0" width="4527" height="8020" 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="00080000af110000541f0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Sequence Container" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4527" vartype="3" /> <property name="LogicalObject" value="{60E7F67E-FB85-4D9B-AFE2-CC338BAE52AC}" 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="MSDDS.Polyline" left="9628" top="-14846" logicalid="10" controlid="10" masterid="0" hint1="0" hint2="0" width="3994" height="3285" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"> <adornment percentpos="24.5391131041355" controlid="38" width="423" height="423" side="0" behavior="2" himetric="1418" distfromline="175" startobj="0" x="11091" y="-14272" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{82F15544-10CB-4167-993B-2E208FCD8166}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="3" destid="8" sourceattachpoint="15" destattachpoint="24" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="10027" y="-14447" /> <point x="12426" y="-14447" /> <point x="12426" y="-11961" /> <point x="13322" y="-11961" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="13766" top="-11037" logicalid="21" controlid="21" masterid="8" hint1="0" hint2="0" width="3704" 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="00080000780e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{accfaadf-63f0-4544-bdfa-002e56f1ae9d}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="6421" top="-11741" logicalid="37" controlid="37" masterid="0" hint1="0" hint2="0" width="3598" 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="000800000e0e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{F7DC796F-BEA1-46D3-A44E-558C6BC05380}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="@EmployeeCount &gt; 0" left="11091" top="-14272" logicalid="38" controlid="38" masterid="10" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" /> </control> <layoutobject> <ddsxmlobj> <property name="RESERVED_IS_DECORATION" value="10" vartype="3" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="7821" top="-14264" logicalid="39" controlid="39" masterid="0" hint1="0" hint2="0" width="820" height="3023" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"> <adornment percentpos="76.5813253012048" controlid="40" width="423" height="423" side="0" behavior="2" himetric="1642" distfromline="175" startobj="0" x="7622" y="-12749" visible="1" allowoverlap="1" usepercent="1" /> </polyline> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{35DE1011-5AFE-48C5-BFB0-E7A439B50E32}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="3" destid="37" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="8241" y="-13865" /> <point x="8241" y="-12803" /> <point x="8220" y="-12803" /> <point x="8220" y="-11741" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="@EmployeeCount == 0" left="7622" top="-12749" logicalid="40" controlid="40" masterid="39" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" /> </control> <layoutobject> <ddsxmlobj> <property name="RESERVED_IS_DECORATION" value="39" vartype="3" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Send Mail Task" left="8697" top="-5444" logicalid="42" controlid="42" masterid="0" hint1="0" hint2="0" width="3122" 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="00080000320c00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{4A7E5216-91F3-4067-9291-B90796BD829F}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Send Mail Task" left="4516" top="-5471" logicalid="43" controlid="43" masterid="0" hint1="0" hint2="0" width="3174" 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="00080000660c00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{F9A61181-6D42-41C0-8A8A-20E60A1FF15C}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="6421" top="-9076" logicalid="46" controlid="46" masterid="0" hint1="0" hint2="0" width="3625" 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="00080000290e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="7821" top="-10976" logicalid="47" controlid="47" masterid="0" hint1="0" hint2="0" width="812" height="2400" 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="1" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{E2B52824-67F7-4FD6-9574-DDF688ED0A73}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="37" destid="46" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="8220" y="-10577" /> <point x="8220" y="-9826" /> <point x="8233" y="-9826" /> <point x="8233" y="-9076" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="9746" top="-10160" logicalid="48" controlid="48" masterid="0" hint1="0" hint2="0" width="3976" height="2066" 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="1" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{8DA0F342-F657-4026-97CB-D921BA4D5DDD}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="8" destid="46" sourceattachpoint="32" destattachpoint="15" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="13322" y="-9761" /> <point x="12559" y="-9761" /> <point x="12559" y="-8494" /> <point x="10046" y="-8494" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="5704" top="-8311" logicalid="49" controlid="49" masterid="0" hint1="0" hint2="0" width="2379" height="3340" 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="{E8D330F7-5CFB-480E-85D4-B8F8DAFA92DB}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="46" destid="43" sourceattachpoint="5" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="7683" y="-7912" /> <point x="7683" y="-6701" /> <point x="6103" y="-6701" /> <point x="6103" y="-5471" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="8384" top="-8311" logicalid="50" controlid="50" masterid="0" hint1="0" hint2="0" width="2274" height="3367" 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="{E494FE58-BC23-4CA1-B856-E6411BA8A377}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="46" destid="42" sourceattachpoint="9" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="8783" y="-7912" /> <point x="8783" y="-6649" /> <point x="10258" y="-6649" /> <point x="10258" y="-5444" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute Process Task" left="13784" top="-13205" logicalid="51" controlid="51" masterid="8" hint1="0" hint2="0" width="3651" 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="00080000430e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{B5381112-030F-4F89-97DD-7E9F58906F4C}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="13758" top="-8626" logicalid="52" controlid="52" masterid="8" hint1="0" hint2="0" width="3703" 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="00080000770e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{90E70BE0-C180-48F0-A959-9F72114A0DD7}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="15210" top="-12440" logicalid="53" controlid="53" masterid="0" hint1="0" hint2="0" width="808" height="1903" 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="{4763D12B-4D80-4E88-B01B-C21E6FB42973}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="51" destid="21" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="15609" y="-12041" /> <point x="15609" y="-11539" /> <point x="15618" y="-11539" /> <point x="15618" y="-11037" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="15210" top="-10272" logicalid="54" controlid="54" masterid="0" hint1="0" hint2="0" width="808" height="2146" 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="{052F3D20-20EE-418A-AC05-55B86AF50A20}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="21" destid="52" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="15618" y="-9873" /> <point x="15618" y="-9249" /> <point x="15609" y="-9249" /> <point x="15609" y="-8626" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="18009" top="-13077" logicalid="55" controlid="55" masterid="0" hint1="0" hint2="0" width="2693" height="891" 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="00020000850a00007b0300000300640000000500008008000080000000002a0001000000900144420100065461686f6d6125005500730065002000740068006500200062006300700020007500740069006c006900740079000d000a0074006f0020006100720063006800690076006500200064006100740061002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="18007" top="-11066" logicalid="56" controlid="56" masterid="0" hint1="0" hint2="0" width="3090" height="1183" 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="00020000120c00009f0400000300640000000500008008000080000000002a0001000000900144420100065461686f6d6140004c006f0067002000640065007400610069006c0073002000610062006f0075007400200074006800650020000d000a006c006f0061006400200061007400740065006d00700074002c00200069006e0063006c007500640069006e00670020000d000a007400680065002000660069006c00650020006e0061006d0065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="18035" top="-8395" logicalid="57" controlid="57" masterid="0" hint1="0" hint2="0" width="3063" 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="00020000f70b0000e50300000300640000000500008008000080000000002a0001000000900144420100065461686f6d611e005400720075006e00630061007400650020007400680065000d000a0045006d0070006c006f00790065006500730020007400610062006c0065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="12056" top="-5352" logicalid="58" controlid="58" masterid="0" hint1="0" hint2="0" width="3249" height="944" 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="00020000b10c0000b00300000300640000000500008008000080000000002a0001000000900144420100065461686f6d612e00530065006e006400200061006e00200065006d00610069006c0020006900660020007400680065000d000a006400610074006100200066006c006f0077002000700072006f00630065007300730020006600610069006c0073002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1048" top="-5299" logicalid="59" controlid="59" masterid="0" hint1="0" hint2="0" width="3328" height="918" 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="00020000000d0000960300000300640000000500008008000080000000002a0001000000900144420100065461686f6d613100530065006e006400200061006e00200065006d00610069006c002000690066002000740068006500200064006100740061000d000a0066006c006f0077002000700072006f0063006500730073002000730075006300630065006500640073002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="3960" top="-8951" logicalid="60" controlid="60" masterid="0" hint1="0" hint2="0" width="2455" height="971" 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="0002000097090000cb0300000300640000000500008008000080000000002a0001000000900144420100065461686f6d611a004c006f006100640020007400680065000d000a0045006d0070006c006f00790065006500730020007400610062006c0065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="3404" top="-11650" logicalid="61" controlid="61" masterid="0" hint1="0" hint2="0" width="3089" height="1262" 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="00020000110c0000ee0400000300640000000500008008000080000000002a0001000000900144420100065461686f6d613c004c006f0067002000640065007400610069006c0073002000610062006f0075007400200074006800650020000d000a006c006f0061006400200061007400740065006d00700074002c00200077006900740068006f007500740020000d000a0061002000660069006c00650020006e0061006d0065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="4066" top="-15009" logicalid="62" controlid="62" masterid="0" hint1="0" hint2="0" width="2243" height="1182" 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="00020000c30800009e0400000300640000000500008008000080000000002a0001000000900144420100065461686f6d613200460069006e006400200074006800650020006e0075006d0062006500720020000d000a006f006600200072006f0077007300200069006e00200074006800650020000d000a0045006d0070006c006f00790065006500730020007400610062006c00650000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="5205" top="-13211" logicalid="63" controlid="63" masterid="0" hint1="0" hint2="0" width="2454" height="891" 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="00020000960900007b0300000300640000000500008008000080000000002a0001000000900144420100065461686f6d61260049006600200063006f0075006e007400200069007300200030002c002000720075006e0020000d000a0045007800650063007500740065002000530051004c0020007400610073006b002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="9648" top="-13342" logicalid="64" controlid="64" masterid="0" hint1="0" hint2="0" width="2666" 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="000200006a0a0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61390049006600200063006f0075006e007400200069007300200067007200650061007400650072000d000a007400680061006e00200030002c002000720075006e0020007400680065000d000a00530065007100750065006e0063006500200063006f006e007400610069006e00650072002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortLeft>-353</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-15909</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{CA7B94ED-12C0-4E93-BA0F-DEBE68A146A8}{153A7459-9411-4A7B-82B2-869B2F092968} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{E2B52824-67F7-4FD6-9574-DDF688ED0A73}{E7691677-C193-4FC6-BC2F-945D052182B9} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{E494FE58-BC23-4CA1-B856-E6411BA8A377}{C00AC0EE-0051-421E-9DB0-DE00B25593F8} <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:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{E8D330F7-5CFB-480E-85D4-B8F8DAFA92DB}{D4EB1560-EB13-406C-B9C7-FD9E9D7328F9}00-100011048576103310 0User000EmployeeCount{15CEDAA6-6A8A-4C4F-9BB0-47EC8A242E3C} 01 0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 0User000Variable{B0DD8945-A70B-4119-9B7A-0285EC0C6AD7} 01Execute SQL task - 1{5654627E-9E1F-41C2-964B-D476ED2AF9EF}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 00-100011048576-110 01 0Execute Process Task;Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01"AdventureWorks.dbo.Employees out C:\\Data\\Employees_" + SUBSTRING( (DT_STR,50,1252) GETDATE(), 1, 10 ) + ".txt -c -T -t,"Execute Process task{B5381112-030F-4F89-97DD-7E9F58906F4C}Execute Process TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess, Microsoft.SqlServer.ExecProcTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Execute SQL task - 3{accfaadf-63f0-4544-bdfa-002e56f1ae9d}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Execute SQL Task - 4{90E70BE0-C180-48F0-A959-9F72114A0DD7}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 02-1Constraint{4763D12B-4D80-4E88-B01B-C21E6FB42973} 02-1Constraint 1{052F3D20-20EE-418A-AC05-55B86AF50A20}Sequence Container{60E7F67E-FB85-4D9B-AFE2-CC338BAE52AC}Sequence ContainerSTOCK:SEQUENCE0 0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Execute SQL Task - 2{F7DC796F-BEA1-46D3-A44E-558C6BC05380}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 0Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Data Flow task{CA2FC2F7-F989-4EB1-A223-5AE53042C3CE}Data Flow TaskDTS.Pipeline.10 0 [HumanResources].[vEmployee] 1252 false 0 0 [dbo].[Employees] 1252 false 3 false false TABLOCK,CHECK_CONSTRAINTS 0 0Send Mail Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Send Mail task - 2{4A7E5216-91F3-4067-9291-B90796BD829F}Send Mail TaskMicrosoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask, Microsoft.SqlServer.SendMailTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 0Send Mail Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-110 01Send Mail task - 1{F9A61181-6D42-41C0-8A8A-20E60A1FF15C}Send Mail TaskMicrosoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask, Microsoft.SqlServer.SendMailTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 03-1@EmployeeCount > 0Constraint 2{82F15544-10CB-4167-993B-2E208FCD8166} 03-1@EmployeeCount == 0Constraint{35DE1011-5AFE-48C5-BFB0-E7A439B50E32} 020Constraint 1{E2B52824-67F7-4FD6-9574-DDF688ED0A73} 020Constraint 3{8DA0F342-F657-4026-97CB-D921BA4D5DDD} 02-1Constraint 4{E8D330F7-5CFB-480E-85D4-B8F8DAFA92DB} 12-1Constraint 5{E494FE58-BC23-4CA1-B856-E6411BA8A377}PrecedenceConstraints{CA7B94ED-12C0-4E93-BA0F-DEBE68A146A8}MSDTS.Package.10