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
User contributions licensed under CC BY-SA 3.0