]]> _
_
Public Class ScriptMain
Inherits UserComponent
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub Input_ProcessInputRow(ByVal Row As InputBuffer)
Try
Dim req As New OrganizationRequest
Dim type As String = Convert.ToString(GetBufferValue_(Row.Buffer, m_typeIndex))
Select Case type.ToLower()
Case "opportunity"
' https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.generatequotefromopportunityrequest.aspx?f=255&MSPPError=-2147217396
req.RequestName = "GenerateQuoteFromOpportunity"
req("OpportunityId") = New Guid(Convert.ToString(Row.Buffer(m_idIndex)))
Case "salesorder"
' https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.convertsalesordertoinvoicerequest.aspx
req.RequestName = "ConvertSalesOrderToInvoice"
req("SalesOrderId") = New Guid(Convert.ToString(Row.Buffer(m_idIndex)))
Case "team"
' https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.convertownerteamtoaccessteamrequest.aspx
req.RequestName = "ConvertOwnerTeamToAccessTeam"
req("TeamId") = New Guid(Convert.ToString(Row.Buffer(m_idIndex)))
Case Else
Throw New Exception(String.Format("Unhandled convert type: {0}", type))
End Select
' Execute action.
Dim res As OrganizationResponse = m_service.Execute(req)
Dim entity As Entity = CType(res("Entity"), Entity)
If Not entity Is Nothing Then
Row.OutputId = entity.Id
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), _
IConnection)
Call m_connection.Connect()
m_service = CType(m_connection.GetService(0), OrganizationServiceClient) ' 0 - CRM Service
' Get input column indexes.
m_typeIndex = GetColumnIndex_("Type")
m_idIndex = GetColumnIndex_("InputId")
End Sub ' PreExecute
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub PostExecute()
Call MyBase.PostExecute()
Call m_connection.Close()
m_typeIndex = -1
m_idIndex = -1
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 Exception("Select Dynamics CRM Connection.")
End If
Dim input As IDTSInput90 = MyBase.ComponentMetaData.InputCollection(0)
If input.IsAttached Then
Dim inputCol As IDTSInputColumn90 = Nothing
inputCol = GetInputColumn_("Type")
If inputCol Is Nothing Then
Throw New Exception("Type column is not mapped.")
End If
inputCol = GetInputColumn_("InputId")
If inputCol Is Nothing Then
Throw New Exception("InputId column is not mapped.")
End If
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 Type column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "Type"
column.DataType = DataType.DT_WSTR
column.Length = 10
' Setup InputId column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "InputId"
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 Convert", _
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
GetInputColumn_ = result
End Function ' GetInputColumn_
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Function GetColumnIndex_(ByVal externalName As String) As Integer
Dim result As Integer = -1
Dim input As IDTSInput90 = MyBase.ComponentMetaData.InputCollection(0)
Dim inputCol As IDTSInputColumn90 = GetInputColumn_(externalName)
If Not inputCol Is Nothing Then
result = Me.HostComponent.BufferManager.FindColumnByLineageID( _
input.Buffer, _
inputCol.LineageID)
End If
GetColumnIndex_ = result
End Function ' GetColumnIndex_
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Function GetBufferValue_( _
ByVal buffer As Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer, _
ByVal index As Integer) As Object
Dim result As Object = Nothing
If index <> -1 AndAlso Not buffer.IsNull(index) Then
result = buffer(index)
End If
GetBufferValue_ = result
End Function ' GetBufferValue_
#End Region ' Internals
#Region "Attributes"
Private m_crmConnection As String
Private m_connection As IConnection
Private m_service As OrganizationServiceClient
Private m_idIndex As Integer
Private m_typeIndex As Integer
#End Region ' Attributes
End Class ' ScriptMain
]]>ScriptComponent_27066129643e4440b6ab85fdba8b2066trueCozyRoc.SqlServer.SSIS.ScriptComponentHostPlus, CozyRoc.SSISPlus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea