Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Failing on foreign characters

Author  Topic 

blodzoom
Starting Member

28 Posts

Posted - 2014-10-30 : 13:13:57
I run a query on one database, save results to a text tab delimited file, then run an SSIS to a destination table in a different database. This has been working for a long time.

I now need to add a "city" column to this process. The source is nvarchar(35). I set the Destination field to nvarchar(100), the data conversion is set to Unicode String DT_WSTR 100

It says Column 49 Returned Status Value 4 and Status text "Text was truncated or one or more characters had no match in the target code page"

Then it specifies a row. That row has this for the city in Japan: “Œ‹ž“s�`‹æ“Œ�V‹´ˆê’š–Ú‹ã”Ô“ñ�†

Any suggestions? This is driving me crazy.

Also, I don't know why they make the errors so that you can't copy and paste them.

CSnoek
Starting Member

3 Posts

Posted - 2014-11-18 : 07:16:27
Hi Bloodzoom,

I have had a similar problem a while ago, but in my case this had to to with the fact that the collation of the originating database was set to Latin1_General_CI_AS and the receiving database was collated using Danish_Norwegian_CI_AS.
Not entirely sure if the problem was 100% identical, but it may be worth looking into.

Hope this helps.
Go to Top of Page
   

- Advertisement -