SSIS Trademark bug

[dmando84]

Hello,

I am trying to import a text file that has some trademarks embedded after the company names. When I import the file I receive a truncation error. I am assuming that the trademark is being interpereted as a binary code of some sort. Has anyone had a problem like this, or is there a work around to this trademark issue? Any help would be appreciated.

Thank you,

David

 

[AlexCuse]

Have you tried importing to a unicode field (nvarchar)?

Hope this helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".