Posted in Data Migration, Dynamics 365, Dynamics CRM, SSIS

SSIS – {The column cannot be processed because more than one code page (1256 and 1252) are specified for it}

Second post in 2017.. hoping for more posts in upcoming days.

Recently, I faced this issue while migrating records from Source database to Staging database.

Package background: I have developed the package in development server and deployed in migration server.

Analysis: I just checked the code page of the error column in dev server. It’s 1252. Was thinking how come 1256 ? .

1951885

Checked the “COLLATION” of Source column name in Development server and Migration server. It was different. Gotcha.

 Its 1256 in Migration server and 1252 in Development server.

Resolution: Now you know what to do.. Just make it same

Tip: Whenever this code page issue occurs, Check the respective column collation.

Hope it will help somebody.

Reach out to me if you need any help to resolve issues in data migration.

Advertisements

Author:

#EnthusiasticTechnologist #Developer #SeniorConsultant #DataLover #DataMigrationSpecialist #DynamicsCRMSpecialist #Challenger #Fitness-freak #Blogger #TechnicalTrainer #TechnologyLover

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s