Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, April 14, 2014 5:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 6:11 AM
Points: 338, Visits: 956
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