The connection manager in this example is created manually using the wizard. It is only referenced in the code not created.

I use Hex Editor Neo, I only use it rarley for instances such as this where I want to "see" hidden characters. Not sure if it is any good or...

If you open up your csv in a hex editor, you'll be able to see what the characters are, then you perhaps have a couple of options.

1)Change your column to...

Hello Karthik,

In Oracle I think you can use

instr(YourColumntoSearch, YourSearchPattern) to replicate the functionality of both PatIndex and charIndex

Garry

Sorry for the late response, hope I am not too late to help,

If you read your XML file into a string variable called MessageQXML then run this as a script...