Sample File should be here

I don't have access right now. I have a column called XMLMessage which stores xml data etc, typical xml but the data type that defines the column...

Getting this error

Msg 4121, Level 16, State 1, Line 1

Cannot find either column "XMLMessage" or the user-defined function or aggregate "XMLMessage.query", or the name is ambiguous.

Here's what i have for double casting

SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML)

Can't really send screen dump for legal reasons.

datatypes are

varchar

varchar

datetime

varchar

varchar

varchar

varchar

datetime

varchar

varchar

varchar

datetime

varchar

varchar

varchar

varchar

datetime

varchar

Here's a copy of the error

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Data Flow Task [Excel Destination [790]]: Columns "Doc.GivenName" and "Document Givenname" cannot convert between unicode and non-unicode...

Forgot to mention. If anyone wants to reply via email they can reach me at emkafkaesque@googlemail.com

Hi All,

Hope someone can help with this. I have tried a few of the solutions around the web but am unable to get this to work.

Here's the problem.....

I am trying...