210/16/2008 12:06:19 PM504010490{8B42BF20-057D-46BB-9D55-1CEDE660432E}-1000 0134.44.28.221.C6DTSConfig.C6Stampe{461cfe4e-8bc6-4311-9f58-864c9698ea5f}OLEDB0Data Source=10.10.32.203;User ID=f701264;Initial Catalog=C6DTSConfig;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False; 0C6 Stampe Centralizzate{EEF8409F-CBBF-435A-AF40-07769B513F9C}OLEDB0Data Source=10.10.32.203;Initial Catalog=C6StampeCentralizzate;Provider=SQLNCLI.1;Integrated Security=SSPI; 1D:\C6_BATCH\SSIS_ContrattoSeiPeriodico\C6DTSConfig.dtsConfigC6DTSConfig{9DEDECBF-D62C-45AF-A69D-D800771CDA73} 7"134.44.28.221.C6DTSConfig.C6Stampe";"[dbo].[SSIS Configurations Periodico]";"DATAMART_STORICIZZAZIONE";Configuration 1{26FE829F-A8EF-4FB1-AC62-AB50452F9369} <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{49921A5C-1C0B-4CC4-843E-D3D87B37126F}{56BD63D7-24BF-4EAE-9569-3181FA4CA9E5} <Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>-34452</dwd:BoundingLeft><dwd:BoundingTop>-8836</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="41" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-35452" scrolltop="-9836" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="26035" y="13600" 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.1" tooltip="Sequence Container" left="-34452" top="-6672" logicalid="20" controlid="1" masterid="0" hint1="0" hint2="0" width="11371" height="13153" 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="000800006b2c000061330000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Parallelizzazione Storicizzazione MART" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="10333" vartype="3" /> <property name="LogicalObject" value="{318e7a2d-6f95-4d92-a8d9-7bc75d818e20}" 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.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-28362" top="-2380" logicalid="21" controlid="2" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 3" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{370be351-629d-439f-b3a3-c61eb4f4b86c}" 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.1" tooltip="Execute SQL Task" left="-28162" top="-1016" logicalid="22" controlid="3" masterid="2" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{69814fec-615e-4480-9df3-3bb6f0011973}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-33428" top="-5308" logicalid="23" controlid="4" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 0" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{d4f1684e-06df-46f4-82bc-722785736cf4}" 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.1" tooltip="Execute SQL Task" left="-33227" top="-3944" logicalid="24" controlid="5" masterid="4" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{98cdd623-503d-45a8-86a9-b91b7349e4cc}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-33427" top="-2380" logicalid="25" controlid="6" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 2" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{f3fee862-f214-499a-af10-40085513b935}" 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.1" tooltip="Execute SQL Task" left="-33227" top="-1016" logicalid="26" controlid="7" masterid="6" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0d6af81f-2ea1-485c-a04e-e4f2bf8e5bbf}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-28362" top="-5308" logicalid="27" controlid="8" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 1" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{23557841-854b-43cb-8e6a-8985e5177c74}" 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.1" tooltip="Execute SQL Task" left="-28162" top="-3944" logicalid="28" controlid="9" masterid="8" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{daec088f-dc3e-4abe-8d7f-ef8fe7b1e778}" 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="-31510" top="-8836" logicalid="29" controlid="10" masterid="0" hint1="0" hint2="0" width="6112" 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="00080000e01700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{0e048eba-e677-4b41-ba75-e0a37a7e29b6}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-29166" top="-8071" logicalid="30" controlid="11" masterid="0" hint1="0" hint2="0" width="1112" height="1899" 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="{49921A5C-1C0B-4CC4-843E-D3D87B37126F}" 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="10" destid="1" sourceattachpoint="11" destattachpoint="20" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="-28454" y="-7672" /> <point x="-28454" y="-7172" /> <point x="-28767" y="-7172" /> <point x="-28767" y="-6672" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-33443" top="558" logicalid="31" controlid="12" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 4" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{3da88cc5-31d8-412a-bc78-4246bbac5577}" 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.1" tooltip="Execute SQL Task" left="-33243" top="1922" logicalid="32" controlid="13" masterid="12" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{c8770ded-a4ac-480a-9778-1cec01027e9b}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-28351" top="587" logicalid="33" controlid="14" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 5" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{3effb332-bcf7-430c-8717-25c2bb983e33}" 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.1" tooltip="Execute SQL Task" left="-28151" top="1951" logicalid="34" controlid="15" masterid="14" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{ab8be365-0ae7-4885-b159-df2ad4cad533}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-33417" top="3450" logicalid="35" controlid="16" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 6" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{be8a5fa7-58a9-41d2-9968-4297448668d4}" 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.1" tooltip="Execute SQL Task" left="-33217" top="4814" logicalid="36" controlid="17" masterid="16" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{d8eddbef-e5ad-41e5-9122-c3930d6319cb}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsContainerObjectManagedBridge.1" tooltip="For Loop Container" left="-28325" top="3485" logicalid="37" controlid="18" masterid="1" hint1="0" hint2="0" width="4868" height="2728" 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="0008000004130000a80a0000" /> </control> <layoutobject> <ddsxmlobj> <property name="Caption" value="Ciclo Storicizzazione 7" vartype="8" /> <property name="CaptionHeight" value="1164" vartype="3" /> <property name="Collapsed" value="0" vartype="11" /> <property name="CollapsedWidth" value="4868" vartype="3" /> <property name="LogicalObject" value="{05188120-e41f-477d-8420-3a7c34ab7196}" 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.1" tooltip="Execute SQL Task" left="-28125" top="4849" logicalid="38" controlid="19" masterid="18" hint1="0" hint2="0" width="3784" 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="00080000c80e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{388bbaa3-30a1-4c59-87a9-89d1118b51b6}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortLeft>-35452</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-9836</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{A66C399D-9BF3-4A3B-BAC2-E5443A1AAE18}{2F66A0F9-4486-46B0-B401-8F1CC2C3AC1D} <ConnectionManager 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:DataSourceID>C6 Stampe Centralizzate</dwd:DataSourceID></ConnectionManager>dts-designer-1.0{EEF8409F-CBBF-435A-AF40-07769B513F9C}{C4F45F53-2AE5-4D76-BAA0-A461B4B96148}00-100011048576104010 0User000tabellaMartDaStoricizzare{BDA4DB20-BACC-489A-B389-CEAD10B3474E} 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 01Truncate C6MartPeriodcio_TabelleStoricizzate{0e048eba-e677-4b41-ba75-e0a37a7e29b6}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910 00-100011048576-110 01 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{388bbaa3-30a1-4c59-87a9-89d1118b51b6}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 7{05188120-e41f-477d-8420-3a7c34ab7196}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{69814fec-615e-4480-9df3-3bb6f0011973}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 3{370be351-629d-439f-b3a3-c61eb4f4b86c}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{ab8be365-0ae7-4885-b159-df2ad4cad533}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 5{3effb332-bcf7-430c-8717-25c2bb983e33}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{daec088f-dc3e-4abe-8d7f-ef8fe7b1e778}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 1{23557841-854b-43cb-8e6a-8985e5177c74}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{0d6af81f-2ea1-485c-a04e-e4f2bf8e5bbf}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 2{f3fee862-f214-499a-af10-40085513b935}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{d8eddbef-e5ad-41e5-9122-c3930d6319cb}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 6{be8a5fa7-58a9-41d2-9968-4297448668d4}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{c8770ded-a4ac-480a-9778-1cec01027e9b}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 4{3da88cc5-31d8-412a-bc78-4246bbac5577}For Loop ContainerSTOCK:FORLOOP0 @tabellaMartDaStoricizzare = 1@tabellaMartDaStoricizzare == 1100-100011048576-110 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 01Storicizza_Tabella{98cdd623-503d-45a8-86a9-b91b7349e4cc}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910Ciclo Storicizzazione 0{d4f1684e-06df-46f4-82bc-722785736cf4}For Loop ContainerSTOCK:FORLOOP0Parallelizzazione Storicizzazione MART{318e7a2d-6f95-4d92-a8d9-7bc75d818e20}Sequence ContainerSTOCK:SEQUENCE0 02-1Constraint 1{49921A5C-1C0B-4CC4-843E-D3D87B37126F}DATAMART_STORICIZZAZIONE{A66C399D-9BF3-4A3B-BAC2-E5443A1AAE18}MSDTS.Package.10