Code Page

Hello,

I am getting following error

Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "dbname" cannot be processed because more than one code page (936 and 1252) are specified for it.

Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "dbsize" cannot be processed because more than one code page (936 and 1252) are specified for it.

Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "Owner" cannot be processed because more than one code page (936 and 1252) are specified for it.

Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "Status" cannot be processed because more than one code page (936 and 1252) are specified for it.

Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "CompLevel" cannot be processed because more than one code page (936 and 1252) are specified for it.

When I run the package itself it is working fine and when I am calling the package from another package getting this error. From Parent package I sending servername for olde db source to this package.

Thanks.

hi Faran

Try by setting "AlwaysUseDefaultCodePage" property of oledb source as true.

Thanks and regards

Rahul Kumar, Software Engineer, India

|||

I also experienced the following error message:

The column

"%1!s!" cannot be processed because more than one code page (%2!d!

and %3!d!) are specified for it.

Here are the details

of my case:

BACKGROUND
While building SSIS

packages graphically within VS 2005 design mode, a metadata code behind page is

modified to reflect the graphical controls used within the designer. It is here

within the metadata code-behind where controls reference their parent page with

a page number. Each SSIS package has a code-behind with a default page number.

Different SSIS packages should have different page numbers.

CAUSE
I was working with

one SSIS package and created a second package that would use some of the

configured controls from the first package. By copying controls from the first

package to the second package, I ended up with several controls using the page

number from its source. So, when I attempted to debug the second package I

received the following message:

The column "ProductId"

cannot be processed because more than one code page (1252 and 65001) are

specified for it.

In short the first

SSIS package had a page number of 1252 and the second SSIS package had a page

number of 65001. So all of the controls copied from the first package retained

their 1252 page number references.

SOLUTION
I edited the metadata

code-behind by replacing all 1252 page number references with 65001.

This solution worked

for me and I hope others will find it useful.

|||

How to set the "AlwaysUseDefaultCodePage" property?

Thank you.

|||

In your data flow transformation, in the properties window of the ole db source or destination you can set this.

Thanks