]]> _
_
Public Class ScriptMain
Inherits UserComponent
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub Input_ProcessInputRow(ByVal Row As InputBuffer)
Try
Dim req As New OrganizationRequest
req.RequestName = "ConvertQuoteToSalesOrder"
' Setup QuoteId.
req("QuoteId") = New Guid(Convert.ToString(Row.Buffer(m_qiIndex)))
Dim value As Object
value = GetBufferValue_(Row.Buffer, m_qcdIndex)
If Not value Is Nothing Then
req("QuoteCloseDate") = Convert.ToDateTime(value)
End If
value = GetBufferValue_(Row.Buffer, m_qcdescIndex)
If Not value Is Nothing Then
req("QuoteCloseDescription") = Convert.ToString(value)
End If
value = GetBufferValue_(Row.Buffer, m_qcsIndex)
If Not value Is Nothing Then
Dim qcs As New OptionSetValue()
qcs.Value = Convert.ToInt32(value)
req("QuoteCloseStatus") = qcs
End If
value = GetBufferValue_(Row.Buffer, m_qcsubjIndex)
If Not value Is Nothing Then
req("QuoteCloseSubject") = Convert.ToString(value)
End If
' Execute action.
Dim res As OrganizationResponse = m_service.Execute(req)
Dim salesOrder As Entity = CType(res("Entity"), Entity)
Row.SalesOrderId = salesOrder.Id
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_qiIndex = GetColumnIndex_("QuoteId")
m_qcdIndex = GetColumnIndex_("QuoteCloseDate")
m_qcdescIndex = GetColumnIndex_("QuoteCloseDescription")
m_qcsIndex = GetColumnIndex_("QuoteCloseStatus")
m_qcsubjIndex = GetColumnIndex_("QuoteCloseSubject")
End Sub ' PreExecute
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Overrides Sub PostExecute()
Call MyBase.PostExecute()
Call m_connection.Close()
m_qiIndex = -1
m_qcdIndex = -1
m_qcdescIndex = -1
m_qcsIndex = -1
m_qcsubjIndex = -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_("QuoteId")
If inputCol Is Nothing Then
Throw New Exception("QuoteId 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 QuoteId column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "QuoteId"
column.DataType = DataType.DT_GUID
' Setup QuoteCloseDate column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "QuoteCloseDate"
column.DataType = DataType.DT_DBTIMESTAMP
' Setup QuoteCloseDescription column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "QuoteCloseDescription"
column.DataType = DataType.DT_WSTR
column.Length = 1000
' Setup QuoteCloseStatus column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "QuoteCloseStatus"
column.DataType = DataType.DT_I4
' Setup QuoteCloseSubject column.
column = input.ExternalMetadataColumnCollection.[New]()
column.Name = "QuoteCloseSubject"
column.DataType = DataType.DT_WSTR
column.Length = 250
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 Quote To Sales Order", _
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_qiIndex As Integer
Private m_qcdIndex As Integer
Private m_qcdescIndex As Integer
Private m_qcsIndex As Integer
Private m_qcsubjIndex As Integer
#End Region ' Attributes
End Class ' ScriptMain
]]>ScriptComponent_3fe65a1a026e44d09602cd9524772938trueCozyRoc.SqlServer.SSIS.ScriptComponentHostPlus, CozyRoc.SSISPlus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea