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.
| 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. |
 |
|
|
|
|
|
SSIS Failing on foreign characters