November 1, 2013 at 11:48 am
I have a SSIS package, loading a file that is UTF-8. It is erroring out about there being cha's in the file that are not found in CodePage 1252. What do I set the CodePage to for UTF-8?
November 1, 2013 at 1:30 pm
Just figured out that Data Flow Path Editor is not the place to make the change... Source Connection is.. then I have to do a data conversion, thank god for the wheel on the mouse... selecting from a drop down (50 times) gets to be a real drag.
November 1, 2013 at 1:31 pm
My data conversion is giving... Error at Data Flow Processing Data, conversion from DT_STR with code 65001 to DT_STR with code page 1252 is not supported... so just how do I get the bloody data to load?
November 4, 2013 at 4:46 am
dwilliscp (11/1/2013)
My data conversion is giving... Error at Data Flow Processing Data, conversion from DT_STR with code 65001 to DT_STR with code page 1252 is not supported... so just how do I get the bloody data to load?
Use Unicode from start to finish?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply