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

The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it. Expand / Collapse
Author
Message
Posted Tuesday, April 02, 2013 1:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:22 PM
Points: 10, Visits: 105
In your dataflow right click your OLE DB Destination and click properties.
In your Properties pane which might be on the right side.
Under Custom Properties there is an option called AlwaysUseDefaultCode to True.
Manually change your DefaultCodePage to the code that it says it can't convert. So in my scenario it said it couldn't do pages 65001 to 1295. I changed the DefaultCodePage 65001. From there your Destination will have a "Warning" on it but you should be able to execute the package now.
Post #1438064
Posted Wednesday, May 15, 2013 3:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 4:07 PM
Points: 101, Visits: 78
This is a really old post, but is still the highest hit when it comes to searching google for this issue so I'll try to explain.
A code page in SSIS corresponds to the specific character encoding used e.g. ASCII is code page 1252 and UTF-8 is code page 65001. SQL Server stores character data using "Collations" corresponding to different code pages. A character encoding is the method in which characters are stored as binary data.
If you are using an OLE DB Destination where the actual destination is a SQL Server instance then you may encounter this error for several reasons.
1. Your "source" text file is UTF-8 and your destination columns are VARCHAR/CHAR datatypes. Note that most UTF-8 (99.9%) files contain unicode data so you should use NVARCHAR/NCHAR datatypes for the destination columns.
2. Your "source" text file is ASCII (code page 1252) and your destination columns are VARCHAR/CHAR datatypes but have a collation that supports double byte characters e.g. Korean_Wansung_CI_AS (code page 949), (I'm not sure if any of the SQL Server VARCHAR collations actually use code page 65001 though). If you never specified the collation when creating the table then you should check to see what the databases default collation is. You can fix the issue by altering the collation of the columns in the destination table to something such as Latin1_General_CI_AS, but I would avoid this if you can't say for certain that there isn't and won't be any non-ASCII characters stored in the data.

Be careful changing code pages if you don't know what they stand for. If SSIS automatically uses a code page of 65001 then you should not change the code page to 1252 as this will cause a corruption of all unicode data in the file, you will know this has happened if you end up with text that looks a bit like this "ㄴㅇ리ㅏ호댜ã…".

I've experienced many frustrations with similar issues to this, so can only hope that this post might save someone else from a little bit of pain.
Post #1452995
Posted Thursday, June 20, 2013 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:30 PM
Points: 2, Visits: 30
In the flat file connnection manager editor, set code page property to 1252(ANSI-LATIN 1).
As it changes some time to other setting and gives this error.
Post #1465701
Posted Tuesday, July 02, 2013 3:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 3:24 PM
Points: 138, Visits: 381
Thanks much! this worked like a charm to me.....
Post #1469782
Posted Wednesday, November 20, 2013 11:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:02 PM
Points: 1, Visits: 3
The likely issue is that you have a source and target that are two different data types (ANSI and UTF8).

Perhaps you ran an SQL statement to dump data from a table directly to disk and it defaulted to the UTF8 format, whereas your SSIS job is trying to load it to ANSI.

Typically, I have to convert whatever flat file I'm using to ANSI (if small, open it in notepad and save it as ANSI) in order to get rid of this issue, but you may be able to get around it in SSIS.

Darn, should have read through to page 2 before posting.
Post #1516156
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse