]]> _
_
_
Public Class ScriptMain
Inherits UserComponent
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub Input_ProcessInputRow(ByVal Row As InputBuffer)
Try
Dim aen As String = CStr(Row.Buffer(m_aenIndex))
Dim aei As Guid = New Guid(Row.Buffer(m_aeiIndex).ToString())
Dim ten As String = CStr(Row.Buffer(m_tenIndex))
Dim tei As Guid = New Guid(Row.Buffer(m_teiIndex).ToString())
If Not m_service2011 Is Nothing Then
' CRM 2011
Dim req As New CRM2011.OrganizationRequest
req.RequestName = "Assign"
' Setup assignee.
Dim assignee As New CRM2011.EntityReference
assignee.LogicalName = aen
assignee.Id = aei
req("Assignee") = assignee
' Setup target.
Dim target As New CRM2011.EntityReference
target.LogicalName = ten
target.Id = tei
req("Target") = target
' Execute action.
Call m_service2011.Execute(req)
ElseIf Not m_service4 Is Nothing Then
' CRM 4.0
Dim req As New CRM4.AssignRequest
' Setup assignee.
Dim assignee As New CRM4.SecurityPrincipal
assignee.Type = CType( _
System.Enum.Parse(GetType(CRM4.SecurityPrincipalType), aen), _
CRM4.SecurityPrincipalType)
assignee.PrincipalId = aei
req.Assignee = assignee
' Setup target.
Dim target As New CRM4.TargetOwnedDynamic
target.EntityName = ten
target.EntityId = tei
req.Target = target
' Execute action.
Call m_service4.Execute(req)
Else
' CRM 3.0
Dim req As New CRM3.AssignRequest
' Setup assignee.
Dim assignee As New CRM3.SecurityPrincipal
assignee.Type = CType( _
System.Enum.Parse(GetType(CRM3.SecurityPrincipalType), aen), _
CRM3.SecurityPrincipalType)
assignee.PrincipalId = aei
req.Assignee = assignee
' Setup target.
Dim target As New CRM3.TargetOwnedDynamic
target.EntityName = ten
target.EntityId = tei
req.Target = target
' Execute action.
Call m_service3.Execute(req)
End If
Catch ex As SoapException
Call FireError_(ex.Detail.InnerXml)
Catch ex As Exception
Call FireError_(ex.Message)
End Try
End Sub ' Input_ProcessInputRow
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub PreExecute()
Call MyBase.PreExecute()
' Setup CRM service.
m_connection = CType( _
Me.Connections.CrmConnection.AcquireConnection(Nothing), _
ICrmConnection)
Call m_connection.Connect()
Dim service As Object = m_connection.GetService(0)
m_service2011 = TryCast(service, CRM2011.OrganizationServiceClient)
If m_service2011 Is Nothing Then
m_service4 = TryCast(m_connection.GetService(0), CRM4.CrmService) ' 0 - CRM Service
If m_service4 Is Nothing Then
m_service3 = TryCast(m_connection.GetService(0), CRM3.CrmService) ' 0 - CRM Service
If m_service3 Is Nothing Then
Throw New Exception("Unhandled service object.")
End If
End If
End If
Dim input As IDTSInput90 = MyBase.ComponentMetaData.InputCollection(0)
Dim inputCol As IDTSInputColumn90
' Get input column indexes.
inputCol = GetInputColumn_("AssigneeEntityName")
m_aenIndex = Me.HostComponent.BufferManager.FindColumnByLineageID( _
input.Buffer, _
inputCol.LineageID)
inputCol = GetInputColumn_("AssigneeEntityId")
m_aeiIndex = Me.HostComponent.BufferManager.FindColumnByLineageID( _
input.Buffer, _
inputCol.LineageID)
inputCol = GetInputColumn_("TargetEntityName")
m_tenIndex = Me.HostComponent.BufferManager.FindColumnByLineageID( _
input.Buffer, _
inputCol.LineageID)
inputCol = GetInputColumn_("TargetEntityId")
m_teiIndex = Me.HostComponent.BufferManager.FindColumnByLineageID( _
input.Buffer, _
inputCol.LineageID)
End Sub ' PreExecute
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub PostExecute()
Call MyBase.PostExecute()
Call m_connection.Close()
End Sub ' PostExecute
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function Validate(ByRef errMessage As String) As Boolean
Dim result As Boolean
Try
If String.IsNullOrEmpty(Me.CrmConnection) Then
Throw New ApplicationException("Select Dynamics CRM connection.")
End If
Dim input As IDTSInput90 = Me.ComponentMetaData.InputCollection(0)
If input.IsAttached AndAlso _
(input.InputColumnCollection.Count = 0 OrElse _
input.InputColumnCollection.Count < 4) Then
Throw New Exception("Map input columns.")
End If
' Store connection information in the runtime connection collection, too.
' Cannot directly use RuntimeConnectionCollection in the property get/set
' because of issues with multi-threading.
Me.ComponentMetaData.RuntimeConnectionCollection("CrmConnection").ConnectionManagerID = Me.CrmConnection
result = True
Catch ex As Exception
result = False
errMessage = ex.Message
End Try
Validate = result
End Function 'Validate
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub ReinitializeMetaData()
Call MyBase.ReinitializeMetaData()
If MyBase.ComponentMetaData.InputCollection.Count = 0 Then
' At least one input must exist.
Throw New Exception("No inputs.")
End If
Dim input As IDTSInput90 = MyBase.ComponentMetaData.InputCollection(0)
' Cleanup.
input.ExternalMetadataColumnCollection.IsUsed = True
Call input.InputColumnCollection.RemoveAll()
Call input.ExternalMetadataColumnCollection.RemoveAll()
Dim column As IDTSExternalMetadataColumn90
' Setup assignee entity.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "AssigneeEntityName"
column.DataType = DataType.DT_WSTR
column.Length = 100
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "AssigneeEntityId"
column.DataType = DataType.DT_GUID
' Setup target entity.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "TargetEntityName"
column.DataType = DataType.DT_WSTR
column.Length = 100
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "TargetEntityId"
column.DataType = DataType.DT_GUID
End Sub ' ReinitializeMetaData
#Region "Properties"
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
_
_
_
Public Property CrmConnection() As String
Get
CrmConnection = m_crmConnection
End Get
Set(ByVal value As String)
m_crmConnection = value
End Set
End Property ' CrmConnection
#End Region ' Properties
#Region "Internals"
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private ReadOnly Property CrmConnectionType() As String()
Get
CrmConnectionType = New String() {"DYNAMICS-CRM"}
End Get
End Property ' CrmConnectionType
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub FireError_(ByVal message As String)
Dim cancel As Boolean = False
Call MyBase.ComponentMetaData.FireError( _
0, _
"Dynamics CRM Assign", _
message, _
String.Empty, _
0, _
cancel)
End Sub ' FireError_
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Function GetInputColumn_(ByVal externalName As String) As IDTSInputColumn90
Dim result As IDTSInputColumn90 = Nothing
Dim input As IDTSInput90 = MyBase.ComponentMetaData.InputCollection(0)
Dim extColumn As IDTSExternalMetadataColumn90 = input.ExternalMetadataColumnCollection(externalName)
' Find input column for specified external column.
For Each inputCol As IDTSInputColumn90 In input.InputColumnCollection
If inputCol.ExternalMetadataColumnID = extColumn.ID Then
' Found input column.
result = inputCol
Exit For
End If
Next
If result Is Nothing Then
Throw New Exception("Input column not found.")
End If
GetInputColumn_ = result
End Function ' GetInputColumn_
#End Region ' Internals
#Region "Attributes"
Private m_crmConnection As String
Private m_connection As ICrmConnection
Private m_service2011 As CRM2011.OrganizationServiceClient
Private m_service4 As CRM4.CrmService
Private m_service3 As CRM4.CrmService
Private m_aenIndex As Integer
Private m_aeiIndex As Integer
Private m_tenIndex As Integer
Private m_teiIndex As Integer
#End Region ' Attributes
End Class ' ScriptMain
]]>ScriptComponent_e157eebf7cc44288a374f53af431365ftrueCozyRoc.SqlServer.SSIS.ScriptComponentHostPlus, CozyRoc.SSISPlus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea