Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Question: How do I pervent Chinese characters from turning into ? (SSIS 2008R2) Expand / Collapse
Posted Monday, April 14, 2014 5:24 AM


Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 467, Visits: 1,563
Phil Parkin (4/14/2014)
Resender (4/14/2014)
There no error message except for the validation error,cause that stops the execution of the rest of the package

I mean are you redirecting error rows - have you checked the error output?

Like this, I mean.

I know what you meant,I tried that, the problem is that if I use the unicode datatype in the source I'm getting no execution what so ever.
I get the build Succeeded - Package Validation Error - Package Stops executing
With the strings and error redirect no rows error but their all the chines characters turn into ?

If that's what you meant
Post #1561434
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse