DISP_E_ARRAYISLOCKED on processing Blob in SSIS .net Transformation Script

0

I've made a vb.net transformation script in SSIS. The Script itself seems to be able to process correctly, but for some reason, all the components downstreams get the error :

Error: An error occurred with the following error message: "System.Runtime.InteropServices.COMException: Memory is locked. (Exception from HRESULT: 0x8002000D (DISP_E_ARRAYISLOCKED)) (SSIS Productivity Pack, v9.0.0.2236 - DtsDebugHost, v13.0.4495.10)".

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim encoding As System.Text.UnicodeEncoding = New System.Text.UnicodeEncoding()
Dim blobContain As Byte() = Row.OBJECTVALUE.GetBlobData(0, Row.OBJECTVALUE.Length)
Dim textContain As String = encoding.GetChars(blobContain)
Dim resultText As String

    resultText = RegexCorrection(textContain, "\[\s*\""Class<java.math.BigDecimal>\"",\s*(\d+\.*\d*)\s*\]")
    resultText = RegexCorrection(textContain, "\[\s*\""Class<java.lang.Long>\"",\s*(\d+\.*\d*)\s*\]")

    Dim resultBlob As Byte() = encoding.GetBytes(resultText.ToCharArray())
    Row.OBJECTVALUE.AddBlobData(resultBlob)
End Sub
vb.net
ssis
asked on Stack Overflow Feb 17, 2020 by OpenStove

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0