670 lines
272 KiB
XML
670 lines
272 KiB
XML
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">ADECCO-81014BD1\adecco</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">ADECCO-81014BD1</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">11/7/2008 3:42:02 PM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">0</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">38</DTS:Property><DTS:Property DTS:Name="VersionGUID">{32EF90EB-A1B1-44BE-BA90-E9E8C9C1A0CC}</DTS:Property><DTS:Property DTS:Name="EnableConfig">-1</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
|
||
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">C6 Stampe Centralizzate</DTS:Property><DTS:Property DTS:Name="DTSID">{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">OLEDB</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Password DTS:Name="Password" Sensitive="1"></DTS:Password><DTS:Property DTS:Name="ConnectionString">Data Source=BFDSREPORTING6;User ID=F701264;Initial Catalog=C6StampeCentralizzate;Provider=SQLNCLI.1;Persist Security Info=True;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
|
||
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">RMNAS02.C6DTSConfig.sa</DTS:Property><DTS:Property DTS:Name="DTSID">{b4e6b018-00f6-440c-9671-81409efedfad}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">OLEDB</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Password DTS:Name="Password" Sensitive="1"></DTS:Password><DTS:Property DTS:Name="ConnectionString">Data Source=BFDSREPORTING6;User ID=F701264;Initial Catalog=C6DTSConfig;Provider=SQLNCLI.1;Auto Translate=False;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
|
||
<DTS:Configuration><DTS:Property DTS:Name="ConfigurationType">1</DTS:Property><DTS:Property DTS:Name="ConfigurationString">D:\C6_BATCH\SSIS\C6DTSConfig.dtsConfig</DTS:Property><DTS:Property DTS:Name="ConfigurationVariable"></DTS:Property><DTS:Property DTS:Name="ObjectName">C6DTSConfig</DTS:Property><DTS:Property DTS:Name="DTSID">{CEA08B77-9565-4641-B6F5-D0F87DC54F71}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Configuration>
|
||
<DTS:Configuration><DTS:Property DTS:Name="ConfigurationType">7</DTS:Property><DTS:Property DTS:Name="ConfigurationString">"RMNAS02.C6DTSConfig.sa";"[dbo].[SSIS Configurations]";"DATAMART_PR_RISCHIO";</DTS:Property><DTS:Property DTS:Name="ConfigurationVariable"></DTS:Property><DTS:Property DTS:Name="ObjectName">DATAMART_PR_RISCHIO</DTS:Property><DTS:Property DTS:Name="DTSID">{CCC5CE1A-0D59-4475-8D49-223165101DC8}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Configuration>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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="21" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1131" scrolltop="-161" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="19976" y="14870" 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="Data Conversion" left="2183" top="3003" logicalid="9" controlid="1" masterid="0" 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="{12988df8-7076-4ffd-8455-8617cd021164}/components/16" 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="4681" top="5167" logicalid="10" controlid="2" masterid="0" hint1="0" hint2="0" width="3466" 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="000800008a0d00008c040000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12988df8-7076-4ffd-8455-8617cd021164}/components/382" 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 Source" left="1376" top="839" logicalid="11" controlid="3" masterid="0" hint1="0" hint2="0" width="5265" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="00080000911400008c040000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12988df8-7076-4ffd-8455-8617cd021164}/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="-131" top="5167" logicalid="12" controlid="4" masterid="0" hint1="0" hint2="0" width="4313" 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="00080000d91000008c040000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12988df8-7076-4ffd-8455-8617cd021164}/components/22" vartype="8" />
|
||
<property name="ShowConnectorSource" value="0" vartype="2" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="1604" logicalid="13" controlid="5" 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="{12988df8-7076-4ffd-8455-8617cd021164}/paths/81" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="3" destid="1" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4008" y="2003" />
|
||
<point x="4008" y="3003" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="1626" top="3768" logicalid="14" controlid="6" masterid="0" hint1="0" hint2="0" width="2232" 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="{12988df8-7076-4ffd-8455-8617cd021164}/paths/82" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="1" destid="4" sourceattachpoint="5" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="3458" y="4167" />
|
||
<point x="3458" y="4667" />
|
||
<point x="2025" y="4667" />
|
||
<point x="2025" y="5167" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="4159" top="3768" logicalid="15" controlid="7" masterid="0" hint1="0" hint2="0" width="2655" 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="255" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"><adornment percentpos="82.4929971988796" controlid="9" width="4152" height="344" side="0" behavior="2" himetric="2356" distfromline="175" startobj="0" x="2087" y="4842" visible="1" allowoverlap="1" usepercent="1" />
|
||
</polyline>
|
||
</ddsxmlobj>
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{12988df8-7076-4ffd-8455-8617cd021164}/paths/399" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4558" y="4167" />
|
||
<point x="4558" y="4667" />
|
||
<point x="6414" y="4667" />
|
||
<point x="6414" y="5167" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Text" left="2087" top="4842" logicalid="17" controlid="9" masterid="7" hint1="0" hint2="0" width="4152" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="000200003810000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d611c004400610074006100200043006f006e00760065007200730069006f006e0020004500720072006f00720020004f007500740070007500740000000000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="AnnotationAdornment" value="-1" vartype="11" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-1131</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-161</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">22 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">382 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">382 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">22 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{12988df8-7076-4ffd-8455-8617cd021164}</DTS:Property><DTS:Property DTS:Name="DTSID">{DA48288E-8DBE-4797-9C12-F11757E5BADA}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:PathAnnotation>PathName</dwd:PathAnnotation><dwd:DestinationName>OLE DB Destination Input</dwd:DestinationName><dwd:SourceName>Data Conversion Error Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{12988df8-7076-4ffd-8455-8617cd021164}-399</DTS:Property><DTS:Property DTS:Name="DTSID">{40A78490-7A15-4A40-AC7F-C251711DA189}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:DestinationName>Data Conversion Input</dwd:DestinationName><dwd:SourceName>OLE DB Source Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{12988df8-7076-4ffd-8455-8617cd021164}-81</DTS:Property><DTS:Property DTS:Name="DTSID">{EA71E0E4-644E-4158-821E-96C96686E27D}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:DestinationName>OLE DB Destination Input</dwd:DestinationName><dwd:SourceName>Data Conversion Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{12988df8-7076-4ffd-8455-8617cd021164}-82</DTS:Property><DTS:Property DTS:Name="DTSID">{BD3B05E3-AD7C-4DBD-B7CC-599561558A0E}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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="22" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1210" scrolltop="-1000" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="20135" y="10186" 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="1296" top="0" logicalid="9" controlid="1" masterid="0" hint1="0" hint2="0" width="5424" 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="00080000301500008c040000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/components/879" vartype="8" />
|
||
<property name="ShowConnectorSource" value="0" vartype="2" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Conversion" left="2183" top="2164" logicalid="10" controlid="2" masterid="0" 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="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/components/1230" 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="4760" top="4328" logicalid="11" controlid="3" masterid="0" hint1="0" hint2="0" width="3466" 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="000800008a0d00008c040000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/components/1292" 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="-210" top="4328" logicalid="12" controlid="4" 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="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/components/964" vartype="8" />
|
||
<property name="ShowConnectorSource" value="0" vartype="2" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="765" logicalid="13" controlid="5" 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="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/paths/1236" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4008" y="1164" />
|
||
<point x="4008" y="2164" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="1626" top="2929" logicalid="14" controlid="6" masterid="0" hint1="0" hint2="0" width="2232" 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="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/paths/1237" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="2" destid="4" sourceattachpoint="5" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="3458" y="3328" />
|
||
<point x="3458" y="3828" />
|
||
<point x="2025" y="3828" />
|
||
<point x="2025" y="4328" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="4159" top="2929" logicalid="15" controlid="7" masterid="0" hint1="0" hint2="0" width="2734" 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="255" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"><adornment percentpos="82.9642248722317" controlid="10" width="4152" height="344" side="0" behavior="2" himetric="2435" distfromline="175" startobj="0" x="2166" y="4003" visible="1" allowoverlap="1" usepercent="1" />
|
||
</polyline>
|
||
</ddsxmlobj>
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="LogicalObject" value="{3aea3847-650e-4a98-a3c0-2be27e4871e2}/paths/1309" vartype="8" />
|
||
<property name="Virtual" value="0" vartype="11" />
|
||
<property name="VisibleAP" value="0" vartype="3" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<connector sourceid="2" destid="3" sourceattachpoint="9" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="4558" y="3328" />
|
||
<point x="4558" y="3828" />
|
||
<point x="6493" y="3828" />
|
||
<point x="6493" y="4328" />
|
||
</connector>
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Text" left="2166" top="4003" logicalid="18" controlid="10" masterid="7" hint1="0" hint2="0" width="4152" height="344" noresize="1" nomove="0" nodefaultattachpoints="1" autodrag="1" usedefaultiddshape="1" selectable="0" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"><control><ddsxmlobjectstreaminitwrapper binary="000200003810000058010000030000000000050000800800008001000000350001000000900144420100065461686f6d611c004400610074006100200043006f006e00760065007200730069006f006e0020004500720072006f00720020004f007500740070007500740000000000" />
|
||
</control>
|
||
<layoutobject><ddsxmlobj><property name="AnnotationAdornment" value="-1" vartype="11" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-1210</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-1000</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">879 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1292 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1292 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">964 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">964 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{3aea3847-650e-4a98-a3c0-2be27e4871e2}</DTS:Property><DTS:Property DTS:Name="DTSID">{6FF57CBB-FA52-4B5C-94C7-5B432163F108}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:DestinationName>Data Conversion Input</dwd:DestinationName><dwd:SourceName>OLE DB Source Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{3aea3847-650e-4a98-a3c0-2be27e4871e2}-1236</DTS:Property><DTS:Property DTS:Name="DTSID">{77BB36D1-50A2-4077-8C44-590DC920132F}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:DestinationName>OLE DB Destination Input</dwd:DestinationName><dwd:SourceName>Data Conversion Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{3aea3847-650e-4a98-a3c0-2be27e4871e2}-1237</DTS:Property><DTS:Property DTS:Name="DTSID">{B9635D55-5F68-4506-8316-B0BCF33E1084}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:PathAnnotation>PathName</dwd:PathAnnotation><dwd:DestinationName>OLE DB Destination Input</dwd:DestinationName><dwd:SourceName>Data Conversion Error Output</dwd:SourceName></PipelinePath></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{3aea3847-650e-4a98-a3c0-2be27e4871e2}-1309</DTS:Property><DTS:Property DTS:Name="DTSID">{B252BA80-760A-4D06-BA0F-03EBB9AFCFFC}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}</DTS:Property><DTS:Property DTS:Name="DTSID">{AF49A613-7C4E-4C30-9428-963770384414}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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: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="14" 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="32597" y="12912" 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="Data Flow Task" left="5898" top="1065" logicalid="6" controlid="1" 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="{3aea3847-650e-4a98-a3c0-2be27e4871e2}" 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="1000" top="1000" logicalid="7" controlid="2" 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="{12988df8-7076-4ffd-8455-8617cd021164}" 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="13332" top="2891" logicalid="8" controlid="3" 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="{39A0597D-F8D9-4E87-8B6E-4CECE5A61605}" 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="13861" top="5749" logicalid="9" 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="{6884CD67-55A9-4054-BC34-6D626514EAFB}" vartype="8" />
|
||
<property name="ShowConnectorSource" value="0" vartype="2" />
|
||
</ddsxmlobj>
|
||
</layoutobject>
|
||
<shape groupshapeid="0" groupnode="0" />
|
||
</ddscontrol>
|
||
<ddscontrol controlprogid="MSDDS.Polyline" left="14732" top="3656" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="1328" height="2593" 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="{B3A6B453-DBCF-48D2-AA62-BA9660436E5E}" 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="4" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
|
||
<point x="15131" y="4055" />
|
||
<point x="15131" y="4902" />
|
||
<point x="15660" y="4902" />
|
||
<point x="15660" y="5749" />
|
||
</connector>
|
||
</ddscontrol>
|
||
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{86BD54C2-F155-4AC1-A260-C1F7932BCC55}</DTS:Property><DTS:Property DTS:Name="DTSID">{E2308851-6FFF-4C86-B7B5-6655091CC54D}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
|
||
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><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:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{B3A6B453-DBCF-48D2-AA62-BA9660436E5E}</DTS:Property><DTS:Property DTS:Name="DTSID">{8E0FBA68-87E8-49D9-BD12-C75178398524}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1040</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
|
||
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
|
||
<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Performs 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;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">-1</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
|
||
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Popola Rischio Dett in Mart</DTS:Property><DTS:Property DTS:Name="DTSID">{12988df8-7076-4ffd-8455-8617cd021164}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">
|
||
<components>
|
||
<component id="382" name="TRONCAMENTI" componentClassID="{E2568105-9550-4F71-A638-B7FE42E66922}" description="OLE DB Destination" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
|
||
<properties>
|
||
<property id="383" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="384" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[ERROR]</property>
|
||
<property id="385" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="386" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
|
||
<property id="387" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="388" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="389" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">3</property>
|
||
<property id="391" name="FastLoadKeepIdentity" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="392" name="FastLoadKeepNulls" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="393" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" description="Specifies options to be used with fast load. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">TABLOCK</property>
|
||
<property id="394" name="FastLoadMaxInsertCommitSize" dataType="System.Int32" state="default" isArray="false" description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
|
||
<connections>
|
||
<connection id="390" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<inputs>
|
||
<input id="395" name="OLE DB Destination Input" description="" hasSideEffects="true" dangling="false" errorOrTruncationOperation="Insert" errorRowDisposition="FailComponent" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="423" name="" description="" lineageId="55" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="417"/>
|
||
<inputColumn id="424" name="" description="" lineageId="58" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="418"/>
|
||
<inputColumn id="425" name="" description="" lineageId="61" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="419"/>
|
||
<inputColumn id="426" name="" description="" lineageId="20" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="420"/>
|
||
<inputColumn id="427" name="" description="" lineageId="21" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="421"/>
|
||
</inputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="417" name="TableName" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="418" name="KeyColumn" description="" precision="0" scale="0" length="55" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="419" name="KeyValue" description="" precision="0" scale="0" length="403" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="420" name="ErrorCode" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="421" name="ErrorColumn" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="422" name="Time" description="" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0"/></externalMetadataColumns></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="396" name="OLE DB Destination Error Output" description="" exclusionGroup="1" synchronousInputId="395" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="397" name="ErrorCode" description="" lineageId="397" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="398" name="ErrorColumn" description="" lineageId="398" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="16" name="Data Conversion" componentClassID="{C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C}" description="Data Conversion" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Data Conversion;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
|
||
<inputs>
|
||
<input id="17" name="Data Conversion Input" description="" hasSideEffects="false" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="329" name="" description="" lineageId="160" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<inputColumn id="330" name="" description="" lineageId="187" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<inputColumn id="331" name="" description="" lineageId="190" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
</inputColumns><externalMetadataColumns isUsed="False"/></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="18" name="Data Conversion Output" description="" exclusionGroup="1" synchronousInputId="17" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="320" name="Copy of COD_AGGREG" description="" lineageId="320" precision="0" scale="0" length="128" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="RedirectRow" externalMetadataColumnId="0"><properties>
|
||
<property id="321" name="SourceInputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Specifies the input column used as the source of data for the conversion." typeConverter="" UITypeEditor="" containsID="true" expressionType="None">160</property>
|
||
<property id="322" name="FastParse" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the column uses the faster, locale-neutral parsing routines." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties></outputColumn>
|
||
<outputColumn id="323" name="Copy of MERCATO_CONTRATT" description="" lineageId="323" precision="0" scale="0" length="30" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="RedirectRow" externalMetadataColumnId="0"><properties>
|
||
<property id="324" name="SourceInputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Specifies the input column used as the source of data for the conversion." typeConverter="" UITypeEditor="" containsID="true" expressionType="None">187</property>
|
||
<property id="325" name="FastParse" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the column uses the faster, locale-neutral parsing routines." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties></outputColumn>
|
||
<outputColumn id="326" name="Copy of DIV_CONTRATT" description="" lineageId="326" precision="0" scale="0" length="30" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="RedirectRow" externalMetadataColumnId="0"><properties>
|
||
<property id="327" name="SourceInputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Specifies the input column used as the source of data for the conversion." typeConverter="" UITypeEditor="" containsID="true" expressionType="None">190</property>
|
||
<property id="328" name="FastParse" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the column uses the faster, locale-neutral parsing routines." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties></outputColumn></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
<output id="19" name="Data Conversion Error Output" description="" exclusionGroup="1" synchronousInputId="17" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="20" name="ErrorCode" description="" lineageId="20" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="21" name="ErrorColumn" description="" lineageId="21" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="22" name="RISCHIO_DETTAGLIO" componentClassID="{E2568105-9550-4F71-A638-B7FE42E66922}" description="OLE DB Destination" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
|
||
<properties>
|
||
<property id="23" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="24" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[C6Mart].[RISCHIO_DETTAGLIO]</property>
|
||
<property id="25" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="26" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
|
||
<property id="27" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="28" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="29" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">3</property>
|
||
<property id="31" name="FastLoadKeepIdentity" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="32" name="FastLoadKeepNulls" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="33" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" description="Specifies options to be used with fast load. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">TABLOCK</property>
|
||
<property id="34" name="FastLoadMaxInsertCommitSize" dataType="System.Int32" state="default" isArray="false" description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
|
||
<connections>
|
||
<connection id="30" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<inputs>
|
||
<input id="35" name="OLE DB Destination Input" description="" hasSideEffects="true" dangling="false" errorOrTruncationOperation="Insert" errorRowDisposition="FailComponent" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="106" name="" description="" lineageId="64" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="100"/>
|
||
<inputColumn id="107" name="" description="" lineageId="67" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="101"/>
|
||
<inputColumn id="110" name="" description="" lineageId="76" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="104"/>
|
||
<inputColumn id="111" name="" description="" lineageId="79" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="105"/>
|
||
<inputColumn id="305" name="" description="" lineageId="166" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="114"/>
|
||
<inputColumn id="307" name="" description="" lineageId="172" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="116"/>
|
||
<inputColumn id="308" name="" description="" lineageId="175" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="117"/>
|
||
<inputColumn id="309" name="" description="" lineageId="178" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="118"/>
|
||
<inputColumn id="310" name="" description="" lineageId="181" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="119"/>
|
||
<inputColumn id="311" name="" description="" lineageId="184" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="120"/>
|
||
<inputColumn id="379" name="" description="" lineageId="320" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="112"/>
|
||
<inputColumn id="380" name="" description="" lineageId="323" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="121"/>
|
||
<inputColumn id="381" name="" description="" lineageId="326" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="122"/>
|
||
<inputColumn id="849" name="" description="" lineageId="798" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="668"/>
|
||
<inputColumn id="850" name="" description="" lineageId="801" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="669"/>
|
||
<inputColumn id="851" name="" description="" lineageId="795" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="672"/>
|
||
</inputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="100" name="RETE" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="101" name="COD_FISCALE" description="" precision="0" scale="0" length="16" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="104" name="ID_ELAB" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
|
||
<externalMetadataColumn id="105" name="TIPO_ELAB" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="112" name="COD_AGGREG" description="" precision="0" scale="0" length="256" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="114" name="VAR_PERC_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="116" name="CVAR_PERC_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="117" name="MCVAR" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="118" name="MCVARP" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="119" name="TIPO_COPERTURA" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="120" name="CTV_AGGREG" description="" precision="15" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="121" name="MERCATO_CONTRATT" description="" precision="0" scale="0" length="30" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="122" name="DIV_CONTRATT" description="" precision="0" scale="0" length="30" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="668" name="VAR_ASSOLUTO_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="669" name="CVAR_ASSOLUTO_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="672" name="CHIAVE_PRODOTTO" description="" precision="0" scale="0" length="128" dataType="str" codePage="1252"/></externalMetadataColumns></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="36" name="OLE DB Destination Error Output" description="" exclusionGroup="1" synchronousInputId="35" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="37" name="ErrorCode" description="" lineageId="37" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="38" name="ErrorColumn" description="" lineageId="38" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="1" name="SP DM_RISCHIO_DETTAGLIO" componentClassID="{2C0A8BE5-1EDC-4353-A0EF-B778599C65A0}" description="OLE DB Source" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="7" pipelineVersion="0" contactInfo="OLE DB Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7">
|
||
<properties>
|
||
<property id="2" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="3" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="4" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="5" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None">EXECUTE C6MART.DM_RISCHIO_DETTAGLIO</property>
|
||
<property id="6" name="SqlCommandVariable" dataType="System.String" state="default" isArray="false" description="The variable that contains the SQL command to be executed." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="7" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="8" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="9" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">2</property>
|
||
<property id="15" name="ParameterMapping" dataType="System.String" state="default" isArray="false" description="The mappings between the parameters in the SQL command and variables." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property></properties>
|
||
<connections>
|
||
<connection id="10" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<outputs>
|
||
<output id="11" name="OLE DB Source Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="55" name="TABLENAME" description="" lineageId="55" precision="0" scale="0" length="17" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="54"/>
|
||
<outputColumn id="58" name="KEYCOLUMN" description="" lineageId="58" precision="0" scale="0" length="29" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="57"/>
|
||
<outputColumn id="61" name="KEYVALUE" description="" lineageId="61" precision="0" scale="0" length="43" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="60"/>
|
||
<outputColumn id="64" name="RETE" description="" lineageId="64" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="63"/>
|
||
<outputColumn id="67" name="COD_FISCALE" description="" lineageId="67" precision="0" scale="0" length="16" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="66"/>
|
||
<outputColumn id="76" name="ID_ELAB" description="" lineageId="76" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="75"/>
|
||
<outputColumn id="79" name="TIPO_ELAB" description="" lineageId="79" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="78"/>
|
||
<outputColumn id="160" name="COD_AGGREG" description="" lineageId="160" precision="0" scale="0" length="255" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="159"/>
|
||
<outputColumn id="166" name="VAR_PERC_PTF" description="" lineageId="166" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="165"/>
|
||
<outputColumn id="172" name="CVAR_PERC_PTF" description="" lineageId="172" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="171"/>
|
||
<outputColumn id="175" name="MCVAR" description="" lineageId="175" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="174"/>
|
||
<outputColumn id="178" name="MCVARP" description="" lineageId="178" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="177"/>
|
||
<outputColumn id="181" name="TIPO_COPERTURA" description="" lineageId="181" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="180"/>
|
||
<outputColumn id="184" name="CTV_AGGREG" description="" lineageId="184" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="183"/>
|
||
<outputColumn id="187" name="MERCATO_CONTRATT" description="" lineageId="187" precision="0" scale="0" length="50" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="186"/>
|
||
<outputColumn id="190" name="DIV_CONTRATT" description="" lineageId="190" precision="0" scale="0" length="50" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="189"/>
|
||
<outputColumn id="795" name="CHIAVE_PRODOTTO" description="" lineageId="795" precision="0" scale="0" length="20" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="794"/>
|
||
<outputColumn id="798" name="VAR_ASSOLUTO_PTF" description="" lineageId="798" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="797"/>
|
||
<outputColumn id="801" name="CVAR_ASSOLUTO_PTF" description="" lineageId="801" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="800"/></outputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="54" name="TABLENAME" description="" precision="0" scale="0" length="17" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="57" name="KEYCOLUMN" description="" precision="0" scale="0" length="29" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="60" name="KEYVALUE" description="" precision="0" scale="0" length="43" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="63" name="RETE" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="66" name="COD_FISCALE" description="" precision="0" scale="0" length="16" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="75" name="ID_ELAB" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
|
||
<externalMetadataColumn id="78" name="TIPO_ELAB" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="159" name="COD_AGGREG" description="" precision="0" scale="0" length="255" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="165" name="VAR_PERC_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="171" name="CVAR_PERC_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="174" name="MCVAR" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="177" name="MCVARP" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="180" name="TIPO_COPERTURA" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="183" name="CTV_AGGREG" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="186" name="MERCATO_CONTRATT" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="189" name="DIV_CONTRATT" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="794" name="CHIAVE_PRODOTTO" description="" precision="0" scale="0" length="20" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="797" name="VAR_ASSOLUTO_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="800" name="CVAR_ASSOLUTO_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/></externalMetadataColumns></output>
|
||
<output id="12" name="OLE DB Source Error Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="56" name="TABLENAME" description="" lineageId="56" precision="0" scale="0" length="17" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="59" name="KEYCOLUMN" description="" lineageId="59" precision="0" scale="0" length="29" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="62" name="KEYVALUE" description="" lineageId="62" precision="0" scale="0" length="43" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="65" name="RETE" description="" lineageId="65" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="68" name="COD_FISCALE" description="" lineageId="68" precision="0" scale="0" length="16" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="161" name="COD_AGGREG" description="" lineageId="161" precision="0" scale="0" length="255" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="796" name="CHIAVE_PRODOTTO" description="" lineageId="796" precision="0" scale="0" length="20" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="799" name="VAR_ASSOLUTO_PTF" description="" lineageId="799" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="167" name="VAR_PERC_PTF" description="" lineageId="167" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="802" name="CVAR_ASSOLUTO_PTF" description="" lineageId="802" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="173" name="CVAR_PERC_PTF" description="" lineageId="173" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="176" name="MCVAR" description="" lineageId="176" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="179" name="MCVARP" description="" lineageId="179" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="182" name="TIPO_COPERTURA" description="" lineageId="182" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="185" name="CTV_AGGREG" description="" lineageId="185" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="188" name="MERCATO_CONTRATT" description="" lineageId="188" precision="0" scale="0" length="50" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="191" name="DIV_CONTRATT" description="" lineageId="191" precision="0" scale="0" length="50" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="77" name="ID_ELAB" description="" lineageId="77" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="80" name="TIPO_ELAB" description="" lineageId="80" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="13" name="ErrorCode" description="" lineageId="13" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="14" name="ErrorColumn" description="" lineageId="14" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
</components>
|
||
<paths>
|
||
<path id="81" name="OLE DB Source Output" description="" startId="11" endId="17"/>
|
||
<path id="82" name="Data Conversion Output" description="" startId="18" endId="35"/>
|
||
<path id="399" name="Data Conversion Error Output" description="" startId="19" endId="395"/>
|
||
</paths></pipeline></DTS:ObjectData></DTS:Executable>
|
||
<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Performs 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;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">-1</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
|
||
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Popola Rischio Aggr in Mart</DTS:Property><DTS:Property DTS:Name="DTSID">{3aea3847-650e-4a98-a3c0-2be27e4871e2}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">
|
||
<components>
|
||
<component id="1292" name="TRONCAMENTI" componentClassID="{E2568105-9550-4F71-A638-B7FE42E66922}" description="OLE DB Destination" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
|
||
<properties>
|
||
<property id="1293" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="1294" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[ERROR]</property>
|
||
<property id="1295" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="1296" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
|
||
<property id="1297" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="1298" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="1299" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">3</property>
|
||
<property id="1301" name="FastLoadKeepIdentity" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="1302" name="FastLoadKeepNulls" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="1303" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" description="Specifies options to be used with fast load. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">TABLOCK</property>
|
||
<property id="1304" name="FastLoadMaxInsertCommitSize" dataType="System.Int32" state="default" isArray="false" description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
|
||
<connections>
|
||
<connection id="1300" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<inputs>
|
||
<input id="1305" name="OLE DB Destination Input" description="" hasSideEffects="true" dangling="false" errorOrTruncationOperation="Insert" errorRowDisposition="FailComponent" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="1333" name="" description="" lineageId="910" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1327"/>
|
||
<inputColumn id="1334" name="" description="" lineageId="913" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1328"/>
|
||
<inputColumn id="1335" name="" description="" lineageId="916" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1329"/>
|
||
<inputColumn id="1336" name="" description="" lineageId="1234" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1330"/>
|
||
<inputColumn id="1337" name="" description="" lineageId="1235" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1331"/>
|
||
</inputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="1327" name="TableName" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1328" name="KeyColumn" description="" precision="0" scale="0" length="55" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1329" name="KeyValue" description="" precision="0" scale="0" length="403" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1330" name="ErrorCode" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1331" name="ErrorColumn" description="" precision="0" scale="0" length="50" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1332" name="Time" description="" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0"/></externalMetadataColumns></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="1306" name="OLE DB Destination Error Output" description="" exclusionGroup="1" synchronousInputId="1305" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="1307" name="ErrorCode" description="" lineageId="1307" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="1308" name="ErrorColumn" description="" lineageId="1308" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="879" name="SP DM_RISCHIO_AGGREGATO" componentClassID="{2C0A8BE5-1EDC-4353-A0EF-B778599C65A0}" description="OLE DB Source" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="7" pipelineVersion="0" contactInfo="OLE DB Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7">
|
||
<properties>
|
||
<property id="880" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="881" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="882" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="883" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None">EXECUTE C6MART.DM_RISCHIO_AGGREGATO</property>
|
||
<property id="884" name="SqlCommandVariable" dataType="System.String" state="default" isArray="false" description="The variable that contains the SQL command to be executed." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="885" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="886" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="887" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">2</property>
|
||
<property id="893" name="ParameterMapping" dataType="System.String" state="default" isArray="false" description="The mappings between the parameters in the SQL command and variables." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property></properties>
|
||
<connections>
|
||
<connection id="888" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<outputs>
|
||
<output id="889" name="OLE DB Source Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="910" name="TABLENAME" description="" lineageId="910" precision="0" scale="0" length="17" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="909"/>
|
||
<outputColumn id="913" name="KEYCOLUMN" description="" lineageId="913" precision="0" scale="0" length="18" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="912"/>
|
||
<outputColumn id="916" name="KEYVALUE" description="" lineageId="916" precision="0" scale="0" length="20" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="915"/>
|
||
<outputColumn id="919" name="RETE" description="" lineageId="919" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="918"/>
|
||
<outputColumn id="922" name="COD_FISCALE" description="" lineageId="922" precision="0" scale="0" length="16" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="921"/>
|
||
<outputColumn id="925" name="COD_AGGREG" description="" lineageId="925" precision="0" scale="0" length="255" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="924"/>
|
||
<outputColumn id="928" name="VAR_ASS_PTF" description="" lineageId="928" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="927"/>
|
||
<outputColumn id="931" name="VAR_PERC_PTF" description="" lineageId="931" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="930"/>
|
||
<outputColumn id="934" name="CVAR_ASS_PTF" description="" lineageId="934" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="933"/>
|
||
<outputColumn id="937" name="CVAR_PERC_PTF" description="" lineageId="937" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="936"/>
|
||
<outputColumn id="940" name="MCVAR" description="" lineageId="940" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="939"/>
|
||
<outputColumn id="943" name="MCVARP" description="" lineageId="943" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="942"/>
|
||
<outputColumn id="946" name="COPERTURA" description="" lineageId="946" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="945"/>
|
||
<outputColumn id="949" name="CTV_AGGREG" description="" lineageId="949" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="948"/>
|
||
<outputColumn id="952" name="ID_ELAB" description="" lineageId="952" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="951"/>
|
||
<outputColumn id="955" name="TIPO_ELAB" description="" lineageId="955" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="954"/>
|
||
<outputColumn id="1488" name="BENEFICIO" description="" lineageId="1488" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="1487"/></outputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="909" name="TABLENAME" description="" precision="0" scale="0" length="17" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="912" name="KEYCOLUMN" description="" precision="0" scale="0" length="18" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="915" name="KEYVALUE" description="" precision="0" scale="0" length="20" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="918" name="RETE" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="921" name="COD_FISCALE" description="" precision="0" scale="0" length="16" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="924" name="COD_AGGREG" description="" precision="0" scale="0" length="255" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="927" name="VAR_ASS_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="930" name="VAR_PERC_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="933" name="CVAR_ASS_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="936" name="CVAR_PERC_PTF" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="939" name="MCVAR" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="942" name="MCVARP" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="945" name="COPERTURA" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="948" name="CTV_AGGREG" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="951" name="ID_ELAB" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
|
||
<externalMetadataColumn id="954" name="TIPO_ELAB" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1487" name="BENEFICIO" description="" precision="19" scale="6" length="0" dataType="numeric" codePage="0"/></externalMetadataColumns></output>
|
||
<output id="890" name="OLE DB Source Error Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="911" name="TABLENAME" description="" lineageId="911" precision="0" scale="0" length="17" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="914" name="KEYCOLUMN" description="" lineageId="914" precision="0" scale="0" length="18" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="917" name="KEYVALUE" description="" lineageId="917" precision="0" scale="0" length="20" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="920" name="RETE" description="" lineageId="920" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="923" name="COD_FISCALE" description="" lineageId="923" precision="0" scale="0" length="16" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="926" name="COD_AGGREG" description="" lineageId="926" precision="0" scale="0" length="255" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="929" name="VAR_ASS_PTF" description="" lineageId="929" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="932" name="VAR_PERC_PTF" description="" lineageId="932" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="935" name="CVAR_ASS_PTF" description="" lineageId="935" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="938" name="CVAR_PERC_PTF" description="" lineageId="938" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="941" name="MCVAR" description="" lineageId="941" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="944" name="MCVARP" description="" lineageId="944" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="1489" name="BENEFICIO" description="" lineageId="1489" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="947" name="COPERTURA" description="" lineageId="947" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="950" name="CTV_AGGREG" description="" lineageId="950" precision="19" scale="6" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="953" name="ID_ELAB" description="" lineageId="953" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="956" name="TIPO_ELAB" description="" lineageId="956" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="891" name="ErrorCode" description="" lineageId="891" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="892" name="ErrorColumn" description="" lineageId="892" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="964" name="RISCHIO_AGGREGATO" componentClassID="{E2568105-9550-4F71-A638-B7FE42E66922}" description="OLE DB Destination" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
|
||
<properties>
|
||
<property id="965" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
|
||
<property id="966" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[C6Mart].[RISCHIO_AGGREGATO]</property>
|
||
<property id="967" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
|
||
<property id="968" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
|
||
<property id="969" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
|
||
<property id="970" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>
|
||
<property id="971" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">3</property>
|
||
<property id="973" name="FastLoadKeepIdentity" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property>
|
||
<property id="974" name="FastLoadKeepNulls" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property>
|
||
<property id="975" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" description="Specifies options to be used with fast load. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">TABLOCK,CHECK_CONSTRAINTS</property>
|
||
<property id="976" name="FastLoadMaxInsertCommitSize" dataType="System.Int32" state="default" isArray="false" description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
|
||
<connections>
|
||
<connection id="972" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}"/></connections>
|
||
<inputs>
|
||
<input id="977" name="OLE DB Destination Input" description="" hasSideEffects="true" dangling="false" errorOrTruncationOperation="Insert" errorRowDisposition="FailComponent" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="1111" name="" description="" lineageId="919" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1098"/>
|
||
<inputColumn id="1112" name="" description="" lineageId="922" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1099"/>
|
||
<inputColumn id="1115" name="" description="" lineageId="931" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1102"/>
|
||
<inputColumn id="1117" name="" description="" lineageId="937" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1104"/>
|
||
<inputColumn id="1118" name="" description="" lineageId="940" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1105"/>
|
||
<inputColumn id="1119" name="" description="" lineageId="943" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1106"/>
|
||
<inputColumn id="1120" name="" description="" lineageId="946" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1107"/>
|
||
<inputColumn id="1121" name="" description="" lineageId="949" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1108"/>
|
||
<inputColumn id="1122" name="" description="" lineageId="952" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1109"/>
|
||
<inputColumn id="1123" name="" description="" lineageId="955" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1110"/>
|
||
<inputColumn id="1291" name="" description="" lineageId="1244" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1100"/>
|
||
<inputColumn id="1655" name="" description="" lineageId="1488" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1566"/>
|
||
<inputColumn id="1701" name="" description="" lineageId="928" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1656"/>
|
||
<inputColumn id="1702" name="" description="" lineageId="934" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="1657"/>
|
||
</inputColumns><externalMetadataColumns isUsed="True">
|
||
<externalMetadataColumn id="1098" name="RETE" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1099" name="COD_FISCALE" description="" precision="0" scale="0" length="16" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1100" name="COD_AGGREG" description="" precision="0" scale="0" length="255" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1102" name="VAR_PERC_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1104" name="CVAR_PERC_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1105" name="MCVAR" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1106" name="MCVARP" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1107" name="COPERTURA" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1108" name="CTV_AGGREG" description="" precision="15" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1109" name="ID_ELAB" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
|
||
<externalMetadataColumn id="1110" name="TIPO_ELAB" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
|
||
<externalMetadataColumn id="1566" name="BENEFICIO" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1656" name="VAR_ASSOLUTO_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/>
|
||
<externalMetadataColumn id="1657" name="CVAR_ASSOLUTO_PTF" description="" precision="12" scale="3" length="0" dataType="numeric" codePage="0"/></externalMetadataColumns></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="978" name="OLE DB Destination Error Output" description="" exclusionGroup="1" synchronousInputId="977" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="979" name="ErrorCode" description="" lineageId="979" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="980" name="ErrorColumn" description="" lineageId="980" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
<component id="1230" name="Data Conversion" componentClassID="{C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C}" description="Data Conversion" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Data Conversion;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
|
||
<inputs>
|
||
<input id="1231" name="Data Conversion Input" description="" hasSideEffects="false" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><inputColumns>
|
||
<inputColumn id="1247" name="" description="" lineageId="925" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
</inputColumns><externalMetadataColumns isUsed="False"/></input>
|
||
</inputs>
|
||
<outputs>
|
||
<output id="1232" name="Data Conversion Output" description="" exclusionGroup="1" synchronousInputId="1231" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="1244" name="Copy of COD_AGGREG" description="" lineageId="1244" precision="0" scale="0" length="255" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="RedirectRow" externalMetadataColumnId="0"><properties>
|
||
<property id="1245" name="SourceInputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Specifies the input column used as the source of data for the conversion." typeConverter="" UITypeEditor="" containsID="true" expressionType="None">925</property>
|
||
<property id="1246" name="FastParse" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the column uses the faster, locale-neutral parsing routines." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties></outputColumn></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
<output id="1233" name="Data Conversion Error Output" description="" exclusionGroup="1" synchronousInputId="1231" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="true" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
|
||
<outputColumn id="1234" name="ErrorCode" description="" lineageId="1234" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="1" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
|
||
<outputColumn id="1235" name="ErrorColumn" description="" lineageId="1235" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
|
||
</outputs>
|
||
</component>
|
||
</components>
|
||
<paths>
|
||
<path id="1236" name="OLE DB Source Output" description="" startId="889" endId="1231"/>
|
||
<path id="1237" name="Data Conversion Output" description="" startId="1232" endId="977"/>
|
||
<path id="1309" name="Data Conversion Error Output" description="" startId="1233" endId="1305"/>
|
||
</paths></pipeline></DTS:ObjectData></DTS:Executable>
|
||
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
|
||
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Popola Rischio Aggregato SQL TASK</DTS:Property><DTS:Property DTS:Name="DTSID">{39A0597D-F8D9-4E87-8B6E-4CECE5A61605}</DTS:Property><DTS:Property DTS:Name="Description">Execute SQL Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="True" SQLTask:BypassPrepare="True" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="[C6Mart].[DM_RISCHIO_AGGREGATO]" SQLTask:ResultType="ResultSetType_None" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"/></DTS:ObjectData></DTS:Executable>
|
||
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
|
||
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">PATRIMONIO EMITTENTI</DTS:Property><DTS:Property DTS:Name="DTSID">{6884CD67-55A9-4054-BC34-6D626514EAFB}</DTS:Property><DTS:Property DTS:Name="Description">Execute SQL Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="True" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="exec c6mart.DM_PATRIMONIO_EMITTENTI" SQLTask:ResultType="ResultSetType_None" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"/></DTS:ObjectData></DTS:Executable>
|
||
<DTS:PrecedenceConstraint><DTS:Property DTS:Name="Value">0</DTS:Property><DTS:Property DTS:Name="EvalOp">2</DTS:Property><DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property><DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Executable IDREF="{39A0597D-F8D9-4E87-8B6E-4CECE5A61605}" DTS:IsFrom="-1"/><DTS:Executable IDREF="{6884CD67-55A9-4054-BC34-6D626514EAFB}" DTS:IsFrom="0"/><DTS:Property DTS:Name="ObjectName">Constraint</DTS:Property><DTS:Property DTS:Name="DTSID">{B3A6B453-DBCF-48D2-AA62-BA9660436E5E}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PrecedenceConstraint><DTS:Property DTS:Name="ObjectName">DATAMART_PR_RISCHIO</DTS:Property><DTS:Property DTS:Name="DTSID">{86BD54C2-F155-4AC1-A260-C1F7932BCC55}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable> |