Hi;

CODE PAGE BACKGROUND:-

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 "column1" 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 1:-

1. I edited the metadata code-behind by replacing all 1252 page number references with 65001.

2:- setting "AlwaysUseDefaultCodePage" property of oledb source as true.

Summary:-

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.