Extract Column Data From Flat File Error Output

Hi Friend,


I am stuck with a problem and need your help. As we know, all columns that go to error flow of flat file source connection are displayed as a single column e.g. FlatFileSourceErrorOutputColumn, but my requirement is to extract the first column value from this FlatFileSourceErrorOutputColumn, my data is dilimeted by "|" pipe operator. I have created a script component to deal with this. However if we take FlatFileSourceErrorOutputColumn column as input column in script component, it comes as BLOB data. I wrote below code in transformation script component to extract BLOB data from column in string form and then do a Left function search to take first column out.

When I am running this script component I am getting '??????????' question marks as a result in Row.Pname.

Can anyone please help me understand if I am doing anything wrong in this script or suggest a better way to take the data out?

I appreciate your help.

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

'

'

Dim Error_Data As String

Dim Column_1 As String

Dim Len As Integer

Dim Buffer As Byte()


Buffer = Row.FlatFileSourceErrorOutputColumn.GetBlobData(0, CInt(Row.FlatFileSourceErrorOutputColumn.Length))




Error_Data = System.Text.Encoding.Unicode.GetString(Buffer)


Len = Error_Data.IndexOf("|")


Column_1 = Left(Error_Data, Len - 1)



Row.Pname = Column_1

End Sub


Thanks,
Kul