2ADECCO-81014BD1\adeccoADECCO-81014BD111/7/2008 3:42:02 PM50-101065{A209F7CF-986C-4D06-BB33-B2B253B9BA28}-10000134.44.28.221.C6DTSConfig.C6Stampe{b4e6b018-00f6-440c-9671-81409efedfad}OLEDB0Data Source=134.44.28.221;User ID=C6Stampe;Initial Catalog=C6DTSConfig;Provider=SQLNCLI.1;Auto Translate=False;0C6 Stampe Centralizzate{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}OLEDB0Data Source=134.44.28.221;User ID=C6Stampe;Initial Catalog=C6StampeCentralizzate;Provider=SQLNCLI.1;Persist Security Info=True;1D:\C6_BATCH\SSIS_ContrattoSeiPeriodico\C6DTSConfig.dtsConfigC6DTSConfig{CEA08B77-9565-4641-B6F5-D0F87DC54F71}7"134.44.28.221.C6DTSConfig.C6Stampe";"[dbo].[SSIS Configurations Periodico]";"DATAMART_EMAIL_PB";DATAMART_EMAIL_PB{BF711FF8-0B69-465D-90D6-80EDBF263BA2}<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="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="25162" y="11721" 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="Executes a custom script." left="1164" top="3003" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="5689" 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="00080000391600008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09d7348a-52cf-4290-8c76-7a95cbda10c2}/components/33" 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="1045" top="5167" logicalid="7" controlid="2" masterid="0" hint1="0" hint2="0" width="5927" 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="00080000271700008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09d7348a-52cf-4290-8c76-7a95cbda10c2}/components/307" 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="79" top="839" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="7858" 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="00080000b21e00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09d7348a-52cf-4290-8c76-7a95cbda10c2}/components/324" 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="9" controlid="4" 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="{09d7348a-52cf-4290-8c76-7a95cbda10c2}/paths/369" 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="1" sourceattachpoint="13" destattachpoint="8" 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="3609" top="3768" logicalid="10" 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="{09d7348a-52cf-4290-8c76-7a95cbda10c2}/paths/431" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="1" destid="2" sourceattachpoint="9" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="4008" y="4167" /> <point x="4008" y="5167" /> </connector> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">324 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">307 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">307 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">324 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>dts-designer-1.0{09d7348a-52cf-4290-8c76-7a95cbda10c2}{A8A0D1B4-CBF0-49DB-BD28-38E4C6B659E9}<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>InputEmail</dwd:DestinationName></PipelinePath>dts-designer-1.0{09d7348a-52cf-4290-8c76-7a95cbda10c2}-369{B0CC9B68-C334-4E4D-BBBB-C2C587D3980E}<PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:SourceName>OutputEmail</dwd:SourceName><dwd:DestinationName>OLE DB Destination Input</dwd:DestinationName></PipelinePath>dts-designer-1.0{09d7348a-52cf-4290-8c76-7a95cbda10c2}-431{0736EFF2-729A-43FB-80BF-68E9582B7724}<ConnectionManager xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DataSourceID>C6 Stampe Centralizzate</dwd:DataSourceID></ConnectionManager>dts-designer-1.0{5FBCB7C3-A3A8-4825-9213-9904CB0FC45B}{D94734D0-8C3B-47A6-AF0A-E9F348792220}<PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint>dts-designer-1.0{7FC8610C-12A4-4A9B-B8AC-D63E3E1CD399}{AD68EEB2-791D-459D-8CD3-BCE1AB09CEF5}<Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingTop>-503</dwd:BoundingTop><dwd:Layout><dds> <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="10" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-1501" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="25162" y="12647" 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="556" top="1661" logicalid="4" controlid="1" masterid="0" hint1="0" hint2="0" width="3863" 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="00080000170f00008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09d7348a-52cf-4290-8c76-7a95cbda10c2}" 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="0" top="-503" logicalid="5" controlid="2" masterid="0" hint1="0" hint2="0" width="4974" 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="000800006e1300008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{84556286-bada-492f-997a-65773098d3c8}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="2088" top="262" logicalid="6" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="1899" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{7FC8610C-12A4-4A9B-B8AC-D63E3E1CD399}" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="2" destid="1" sourceattachpoint="9" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="2487" y="661" /> <point x="2487" y="1661" /> </connector> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>-1501</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package>dts-designer-1.0{86BD54C2-F155-4AC1-A260-C1F7932BCC55}{6EEB23BE-3A4E-4CA4-A9CE-754E4B9E02E5}00-1000110485761040100User00HPAmbiente{61673BE0-9D9B-4507-B4B1-F36C68F7D1E7}0User00Email.Pb@hp.comFakePbEmail{F7347A22-798E-463D-AE9C-05CEC588BD02}0User00RootDSERootActiveDirectory{697040BA-679C-491A-B418-8F486B15341E}010Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-110011048576-11001Popolazione Struttura Rete{84556286-bada-492f-997a-65773098d3c8}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-11001Recupero Email PB{09d7348a-52cf-4290-8c76-7a95cbda10c2}Data Flow TaskDTS.Pipeline.10 ]]> "" Then 'Valori = Split(strUserid, ";")(0) 'For i = 0 To UBound(Valori) 'If InStr(Valori(i), "@") Then 'EMailAddress += Valori(i) 'Else Dim Root As New System.DirectoryServices.DirectoryEntry("LDAP://" & Me.Variables.RootActiveDirectory) Dim DomainNC As String = Root.Properties("defaultNamingContext").Value.ToString Root = New System.DirectoryServices.DirectoryEntry("LDAP://" & DomainNC) Dim Searcher As New System.DirectoryServices.DirectorySearcher(Root) With Searcher .Filter = "(sAMAccountName=" & strUserid & ")" .SearchScope = System.DirectoryServices.SearchScope.Subtree .PropertiesToLoad.Add("mail") End With Dim Result As System.DirectoryServices.SearchResult = Searcher.FindOne If Not Result Is Nothing Then EMailAddress += Result.GetDirectoryEntry.Properties("mail").Value.ToString End If End If 'If i < UBound(Valori) Then EMailAddress += ";" 'Next 'End If End If Return EMailAddress End Function End Class ]]>ScriptComponent_250f513c1ef34ccc8b24353476f714f3trueAmbiente,FakePbEmail,RootActiveDirectoryMicrosoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

0[C6MartPeriodico].[EMAIL_PB]1252false3falsefalseTABLOCK0

0[C6Mart].[EMAIL_PB]EXECUTE [C6MartPeriodico].[DM_EMAIL_PB]1252false2

02-1Constraint{7FC8610C-12A4-4A9B-B8AC-D63E3E1CD399}DATAMART_EMAIL_PB{86BD54C2-F155-4AC1-A260-C1F7932BCC55}MSDTS.Package.10