210/16/2008 12:06:19 PM508010522{E9DA22E5-3660-4657-AB37-E82068B3C1CB}-1000
0C6 Stampe Centralizzate{EEF8409F-CBBF-435A-AF40-07769B513F9C}OLEDB0Data Source=BFDSREPORTING6;User ID=F701264;Initial Catalog=C6StampeCentralizzate;Provider=SQLNCLI.1;Persist Security Info=True;
0RMNAS02.C6DTSConfig.sa{D95BA5E2-1619-4637-9137-90796636A97B}OLEDB0Data Source=BFDSREPORTING6;User ID=F701264;Initial Catalog=C6DTSConfig;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;
1D:\C6_BATCH\SSIS\C6DTSConfig.dtsConfigC6DTSConfig{9DEDECBF-D62C-45AF-A69D-D800771CDA73}
7"RMNAS02.C6DTSConfig.sa";"[dbo].[SSIS Configurations]";"DM_ALLINEAMENTO_PORTAFOGLIO";DM_ALLINEAMENTO_PORTAFOGLIO{41077B9F-E03E-486D-BED2-36EA80CE889F}
<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{22286584-9128-4A0C-BD39-53230E3E0B83}{DD075E7F-2F73-429A-B717-6C8FFB7D7EA9}
<DtsEventHandler 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:DtsEventHandlerDiagram><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="3" 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="19156" y="13970" 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="01010000900180380100065461686f6d61" />
</font>
<mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager><ddsxmlobj />
</layoutmanager>
</dds></dwd:Layout></dwd:DtsEventHandlerDiagram></DtsEventHandler>dts-designer-1.0{276ED258-18F4-4151-9398-00896293E7F7}{63783F3E-EA5E-4F11-86D5-379713BD7B07}
<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{8FEEB8A2-BAC0-4AB7-9462-564940350AE4}{EC4F7B4E-64C1-4616-BF01-BB02ED99D81E}
<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>-10112</dwd:BoundingLeft><dwd:BoundingTop>-3231</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="30" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-11112" scrolltop="-4231" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="33338" y="20532" 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="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Allineamento delle Posizioni" left="-10112" top="-609" logicalid="14" controlid="1" 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="{2755b501-ba6e-4569-8e7e-9c2f466db72e}" 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="-9795" top="4137" logicalid="15" controlid="2" masterid="0" 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="{AA302ADA-6188-45E5-BAA3-55EA6345D374}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Script Task" left="-9795" top="2106" logicalid="16" controlid="3" masterid="0" hint1="0" hint2="0" width="4048" 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="00080000d00f00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{799a2e5a-328c-4f52-bf11-6ea621999825}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-8302" top="2871" logicalid="17" controlid="4" masterid="0" hint1="0" hint2="0" width="931" height="1766" 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="{8FEEB8A2-BAC0-4AB7-9462-564940350AE4}" 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="2" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-7771" y="3270" />
<point x="-7771" y="3703" />
<point x="-7903" y="3703" />
<point x="-7903" y="4137" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-8170" top="156" logicalid="18" controlid="5" masterid="0" hint1="0" hint2="0" width="932" height="2450" 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="{DAFDE095-E968-455D-8392-E29CFFB12E02}" 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="1" destid="3" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-7638" y="555" />
<point x="-7638" y="1330" />
<point x="-7771" y="1330" />
<point x="-7771" y="2106" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="-9078" top="-3231" logicalid="19" controlid="6" 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="{b7dc45e1-a07a-4c24-8965-39d3ee05ef54}" 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="-3747" top="6497" logicalid="20" controlid="7" 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="{362023ba-2f4f-4e1b-897c-91f69c96efdf}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-8037" top="-2466" logicalid="21" controlid="8" masterid="0" hint1="0" hint2="0" width="1158" height="2357" 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="{C04B4FBC-2A98-40B8-8B2F-5BE5A7FF030E}" 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="6" destid="1" sourceattachpoint="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-7279" y="-2067" />
<point x="-7279" y="-1338" />
<point x="-7638" y="-1338" />
<point x="-7638" y="-609" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-8302" top="4902" logicalid="22" controlid="9" masterid="0" hint1="0" hint2="0" width="6204" height="2095" 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="{F05BC530-F28B-4911-A509-D4CAAA40D61F}" 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="2" destid="7" sourceattachpoint="7" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-7903" y="5301" />
<point x="-7903" y="5899" />
<point x="-2498" y="5899" />
<point x="-2498" y="6497" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute Process Task" left="-1217" top="3177" logicalid="23" controlid="10" masterid="0" hint1="0" hint2="0" width="4816" height="2407" 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="00080000d012000067090000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{85A74150-4B3C-4ADE-A0AE-CB29A758A5A5}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-7487" top="156" logicalid="24" controlid="11" masterid="0" hint1="0" hint2="0" width="9078" height="3521" 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="{F6D40452-633B-4B28-8F74-683741229CDF}" 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="1" destid="10" sourceattachpoint="11" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-7088" y="555" />
<point x="-7088" y="1866" />
<point x="1191" y="1866" />
<point x="1191" y="3177" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-1797" top="5185" logicalid="25" controlid="12" masterid="0" hint1="0" hint2="0" width="3388" height="1812" 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="{22286584-9128-4A0C-BD39-53230E3E0B83}" 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="7" sourceattachpoint="9" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="1191" y="5584" />
<point x="1191" y="6040" />
<point x="-1398" y="6040" />
<point x="-1398" y="6497" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="-7064" top="1035" logicalid="26" controlid="13" masterid="0" hint1="0" hint2="0" width="10260" height="653" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00020000142800008d0200000300640000000500008008000080000000002a0001000000900144420100065461686f6d614c0053006f00730074006900740075007a0069006f006e006500200063006800690061006d0061007400610020006100200057005300200061006e00670072006100660069006300610020007400720061006d00690074006500200044004c004c0020006f00620073006f006c006500740061002000650020006e006f006e0020007200650066006500720065006e007a00690061007400610000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-11112</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-4231</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{A66C399D-9BF3-4A3B-BAC2-E5443A1AAE18}{B4277DAF-2AEC-4E37-A53B-1A6FA8455FB3}
<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: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="10" 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="40217" y="14526" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager><ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="OLE DB Source" left="2871" top="3016" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="2302" 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="00080000fe0800008c040000" />
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{AA302ADA-6188-45E5-BAA3-55EA6345D374}/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="Executes a custom script." left="2264" top="5180" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="3519" 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="00080000bf0d00008c040000" />
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{AA302ADA-6188-45E5-BAA3-55EA6345D374}/components/88" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3623" top="3781" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="800" 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="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{AA302ADA-6188-45E5-BAA3-55EA6345D374}/paths/99" 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="1" destid="2" sourceattachpoint="3" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4022" y="4180" />
<point x="4022" y="4680" />
<point x="4023" y="4680" />
<point x="4023" y="5180" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{AA302ADA-6188-45E5-BAA3-55EA6345D374}{67142FB5-5273-4290-B237-52C29457BD0C}
<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>CLIENTI</dwd:DestinationName></PipelinePath>dts-designer-1.0{AA302ADA-6188-45E5-BAA3-55EA6345D374}-99{8FD92DB6-E5B1-4D5D-88BD-A7E2A8E6F788}
<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{C04B4FBC-2A98-40B8-8B2F-5BE5A7FF030E}{087EFAF3-3D14-4162-8059-504C9BC277B8}
<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{DAFDE095-E968-455D-8392-E29CFFB12E02}{E2490223-D330-4F83-A9A7-8CF6111FF782}
<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}{74398E8B-9766-4414-8C5E-F10ABCBE1776}
<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{F05BC530-F28B-4911-A509-D4CAAA40D61F}{9AEAE49C-5C76-470F-9CC1-2176F4221947}
<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{F6D40452-633B-4B28-8F74-683741229CDF}{D8E88CC4-F26B-4964-8466-088942F34A7C}00-100011048576104010
0User00WCWcodiceApplicazione{42BCDB56-A1BD-4E11-8AC3-D38567484358}
0User00contrseiconnPwd{0045E82F-B98C-47F0-A523-1A1F668014A9}
0User00M700001nomeUtente{2B582BBA-21F7-4C4B-B356-3631E1A6E8FC}
0User0020noRecordCodeError{0D0EC61E-D1AF-41E7-8376-47CAA2893237}
0User00M7000010password{48AAA2FA-66C6-4AEE-AA8C-58CEF76D0178}
0User00proxy{7AB85001-9E48-48CC-8F31-07ECC3C7E92D}
0User001176versioneDatabaseSIMPBF{8A070B11-2E50-4BFC-8556-2832AB7CCC86}
0User00236versioneDatabaseSIMPBS{D6930871-7BD6-44F9-B043-DFAFB97FB905}
0User00http://eswvwservices/wsnac/anagrafica.asmxwsAnagrafica{4312F719-1F3B-4D90-BEE8-A3AA23608A58}
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
01START LOG{b7dc45e1-a07a-4c24-8965-39d3ee05ef54}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
01Allineamento delle Posizioni{2755b501-ba6e-4569-8e7e-9c2f466db72e}Allineamento delle PosizioniMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910
000-1-10011048576-110
01Recupero token WS{799a2e5a-328c-4f52-bf11-6ea621999825}Script TaskMicrosoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910
188497032OnError00-100011048576-110
0System00-1Propagate{3B1E1FBB-FE03-420B-9FB3-54C774A4E7EF}The propagate property of the event
01{276ED258-18F4-4151-9398-00896293E7F7}OnError
]]>
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-1-10011048576-110
01Clienti non migrati{AA302ADA-6188-45E5-BAA3-55EA6345D374}Data Flow TaskDTS.Pipeline.10
0
EXEC C6MART.DM_CLIENTI_NON_MIGRATI
1252
false
2
]]> 0 Then
Dim dtRow As DataRow
Dim data As DateTime
With sqlCmd
.Parameters("@Rete").Value = Row.RETE
.Parameters("@CodiceFiscale").Value = Row.CODFISCALE
End With
For i As Integer = 0 To rowsCliente - 1
dtRow = dtCliente.Rows(i)
With sqlCmd
.Parameters("@Nome").Value = dtRow("NOME").ToString()
.Parameters("@Cognome").Value = dtRow("COGNOME").ToString()
If Not String.IsNullOrEmpty(dtRow("DATADINASCITA").ToString) Then
data = Functions.ToDateTime(dtRow("DATADINASCITA").ToString)
If data <> DateTime.MinValue Then
.Parameters("@DataNascita").Value = data
End If
End If
.Parameters("@Sesso").Value = dtRow("SESSO").ToString()
.Parameters("@Cittadinanza").Value = dtRow("CITTADINANZA").ToString()
If Not String.IsNullOrEmpty(dtRow("DATAATTIVAZIONECLIENTE").ToString) Then
data = Functions.ToDateTime(dtRow("DATAATTIVAZIONECLIENTE").ToString)
If data <> DateTime.MinValue Then
.Parameters("@DataInizio").Value = data
End If
End If
End With
Next
dtIndirizzo = wsWrapper.GetIndirizzi(chiave, "1", info)
Dim rowsIndirizzo As Integer = dtIndirizzo.Rows.Count
If rowsIndirizzo > 0 Then
For i As Integer = 0 To rowsIndirizzo - 1
dtRow = dtIndirizzo.Rows(i)
With sqlCmd
.Parameters("@Indirizzo").Value = dtRow("INDIRIZZO").ToString
.Parameters("@Localita").Value = dtRow("CITTA").ToString()
.Parameters("@Provincia").Value = dtRow("PROVINCIA").ToString()
.Parameters("@CAP").Value = dtRow("CAP").ToString()
.Parameters("@Nazione").Value = dtRow("NAZIONE").ToString()
End With
Next
End If
sqlConn.Open()
sqlCmd.ExecuteNonQuery()
sqlConn.Close()
End If
End Sub
Public Overrides Sub PostExecute()
wsWrapper = Nothing
info = Nothing
chiave = Nothing
Thread.CurrentThread.CurrentCulture = culture
End Sub
Public Overrides Sub ReleaseConnections()
'connMgr.ReleaseConnection(sqlConn)
End Sub
End Class
]]>
ScriptComponent_511f3d37e4ad4918a429537a628786c0
true
codiceApplicazione,nomeUtente,noRecordCodeError,password,proxy,versioneDatabaseSIMPBF,versioneDatabaseSIMPBS,wsAnagrafica,connPwd
Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
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
01Aggiornamento Clienti da WSAnagrafica ( tramite SIMPB_Wrapper){85A74150-4B3C-4ADE-A0AE-CB29A758A5A5}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
01FINISH LOG{362023ba-2f4f-4e1b-897c-91f69c96efdf}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910
02-1Constraint 2{8FEEB8A2-BAC0-4AB7-9462-564940350AE4}
02-1Constraint{DAFDE095-E968-455D-8392-E29CFFB12E02}
02-1Constraint 1{C04B4FBC-2A98-40B8-8B2F-5BE5A7FF030E}
02-1Constraint 3{F05BC530-F28B-4911-A509-D4CAAA40D61F}
02-1Constraint 4{F6D40452-633B-4B28-8F74-683741229CDF}
02-1Constraint 5{22286584-9128-4A0C-BD39-53230E3E0B83}DM_ALLINEAMENTO_PORTAFOGLIO{A66C399D-9BF3-4A3B-BAC2-E5443A1AAE18}MSDTS.Package.10