Hi, this is my first post
I have a 3rd party adapter in SSIS - which gives an error "'.', hexadecimal value 0x00, is an invalid character. Line 1, position 234.". - but only when importing a particular column, so it must be something to do with the data in that column.
How can I construct a query to identify rows which contain a hex 0x00 character. Note no rows contain NULL, and most rows contain over 1000 characters in the nvarchar(MAX) column that is giving the error.
Thanks in advance for any advice