2FIDEURAM\m800102BFDSC60110/13/2009 10:08:55 AM50-101012{444756DA-9B1E-467E-B27C-AB470E16C184}-10000134.44.28.221.C6DTSConfig.C6Stampe{e961f05c-e4ee-4162-b45c-ab18a473d184}OLEDB0Data Source=10.10.32.85;User ID=f701264;Initial Catalog=C6DTSConfig;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;0LocalHost.C6StampeCentralizzate{3DEC4230-05B1-4E0B-BA8A-3BDAE977B23C}OLEDB0Data Source=LocalHost;Initial Catalog=C6StampeCentralizzate;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;0SEI_PROD.M700143{C5C554F3-A065-4A92-970A-590F34E9CB7B}OLEDB0Data Source=SEI_PROD;User ID=M700143;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;1D:\C6_BATCH\SSIS_ContrattoSeiPeriodico\C6DTSConfig.dtsConfigC6DTSCONFIG{255D7B0F-F604-472C-AF98-952858A88A59}7"134.44.28.221.C6DTSConfig.C6Stampe";"[dbo].[SSIS Configurations Periodico]";"PHOTO_DATA";PHOTO_DATA{9272DABB-59A4-4D8F-9C8F-68D541005FF6}<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{25DAD128-CEA3-4612-8E23-2E676BF8CA35}{A9F5EA78-9B63-44A5-9646-A5D7EC204D22}<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:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>1000</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.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="24897" y="12726" 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="1786" top="3016" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="4471" 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="00080000771100008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{3694A589-76B6-4B28-90C0-DF5A6EA43371}/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="1600" top="5180" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="4842" 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="00080000ea1200008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{3694A589-76B6-4B28-90C0-DF5A6EA43371}/components/414" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3622" top="3781" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" 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="{3694A589-76B6-4B28-90C0-DF5A6EA43371}/paths/431" 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="7" destattachpoint="8" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="4021" y="4180" />
<point x="4021" y="5180" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">414 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">414 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{3694A589-76B6-4B28-90C0-DF5A6EA43371}{84371EA6-722C-4BE6-BCDC-F8FE8FF16B39}<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{3694A589-76B6-4B28-90C0-DF5A6EA43371}-431{46687278-BAC7-4FA3-92CD-4BA6277338D9}<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>1000</dwd:BoundingLeft><dwd:BoundingTop>1000</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.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="24897" y="13653" 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="Execute SQL Task" left="1000" top="1000" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="4366" 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="000800000e1100008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{39999E03-A474-4612-9DD1-3137816659E0}" 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="1053" top="3164" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="4260" 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="00080000a41000008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{3694A589-76B6-4B28-90C0-DF5A6EA43371}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="2784" top="1765" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" 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="{25DAD128-CEA3-4612-8E23-2E676BF8CA35}" 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="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="3183" y="2164" />
<point x="3183" y="3164" />
</connector>
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{BAC4A4CF-DE58-4C71-95D1-3EB05E547093}{497655AA-D27C-47C9-952A-94B7114767E5}00-1000110485761033100User00'BRNVNI29L60A560B','TRRGPP46C19F206A','CSTCNZ72R67F704J','PRSRNT53C30B140P','SCRRFL70H45F952U','SPZCLD61B13H786A','ZMBFNC49L21F990S','BRTLNI27T07E715S','MNFFCM22D64G480P'CodiciFiscali{3101C65A-EF89-4609-A72C-B7CC90502676}010Execute 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"DELETE FROM C6StagingPeriodico.PHOTO_DATA WHERE ADBKID IN (" + @[User::CodiciFiscali] + ")"-1User00DELETE FROM C6StagingPeriodico.PHOTO_DATA WHERE ADBKID IN ('BRNVNI29L60A560B','TRRGPP46C19F206A','CSTCNZ72R67F704J','PRSRNT53C30B140P','SCRRFL70H45F952U','SPZCLD61B13H786A','ZMBFNC49L21F990S','BRTLNI27T07E715S','MNFFCM22D64G480P')SQL{E29E69F5-750C-4A01-A98A-0E9BB3B56FBD}01DELETE PHOTO_DATA{39999E03-A474-4612-9DD1-3137816659E0}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Performs 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"SELECT \"OID$\", \"VERSION$\", ADBKID, INSTID, CAST(C_DATAREQ_EB2B5 AS DATE) AS C_DATAREQ_EB2B5, \"TYPE$_TYPE_7CAB6\", \"TYPE$_STATUS_1E30E\", CAST(C_DATASALVAT_D40E3 AS DATE) AS C_DATASALVAT_D40E3, C_CTVINV_990D8, C_CTVRIS_43FEA, C_CTVLIQ_54D1B, C_CTVPRE_A0E49, C_CTVEXT_34DCC, C_CTVCC_E242D, C_CTVNA_473EA, C_VAR_16494, C_COPVAR_5C6E5, C_INVESTIMEN_5F936, CAST(CODICE_PROFILO AS INT) AS CODICE_PROFILO, CAST(VAR_MAX_PROFILO AS NUMBER(18,2)) AS VAR_MAX_PROFILO FROM PHOTO_DATA WHERE ADBKID IN (" + @[User::CodiciFiscali] + ")"-1User00SELECT "OID$", "VERSION$", ADBKID, INSTID, CAST(C_DATAREQ_EB2B5 AS DATE) AS C_DATAREQ_EB2B5, "TYPE$_TYPE_7CAB6", "TYPE$_STATUS_1E30E", CAST(C_DATASALVAT_D40E3 AS DATE) AS C_DATASALVAT_D40E3, C_CTVINV_990D8, C_CTVRIS_43FEA, C_CTVLIQ_54D1B, C_CTVPRE_A0E49, C_CTVEXT_34DCC, C_CTVCC_E242D, C_CTVNA_473EA, C_VAR_16494, C_COPVAR_5C6E5, C_INVESTIMEN_5F936, CAST(CODICE_PROFILO AS INT) AS CODICE_PROFILO, CAST(VAR_MAX_PROFILO AS NUMBER(18,2)) AS VAR_MAX_PROFILO FROM PHOTO_DATA WHERE ADBKID IN ('BRNVNI29L60A560B','TRRGPP46C19F206A','CSTCNZ72R67F704J','PRSRNT53C30B140P','SCRRFL70H45F952U','SPZCLD61B13H786A','ZMBFNC49L21F990S','BRTLNI27T07E715S','MNFFCM22D64G480P')SQL{97E486C7-E32F-4C5A-A53A-97AB6871E3D1}01Popola PHOTO_DATA{3694A589-76B6-4B28-90C0-DF5A6EA43371}Data Flow TaskDTS.Pipeline.100[C6StagingPeriodico].[PHOTO_DATA]1252false3falsefalseTABLOCK,CHECK_CONSTRAINTS00User::SQL1252true302-1Constraint{25DAD128-CEA3-4612-8E23-2E676BF8CA35}PHOTO_DATA{BAC4A4CF-DE58-4C71-95D1-3EB05E547093}MSDTS.Package.10