Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Using the import/export wizard I end up with an annoying problem:

Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are specified for it.

Looks like a different codepage (SQL_Latin1_General_CI_AS vs Latin1_General_CI_AS), so I changed those to match: Latin1_General_CI_AS for both.

However the wizard still throws an error and detects two codepages - I even checked the tables and both source and dest show the same Latin1_General_CI_AS collation.

share|improve this question
    
What database are you using? –  Phil Aug 5 '12 at 2:16
    
Plus, why are you trying to steal "pinNumber" ? :) –  Phil Aug 5 '12 at 2:17
    
Is this between two instances of SQL Server on different hosts, or between two instances of SQL Server on the same host, or two databases on the same instance? SQL Server sets the code page (based on the Windows code page) for an instance when you install it, and AFAIK that can't be changed. –  Simon Righarts Aug 5 '12 at 10:37
    
one is MSSQL 2005 and other is 2008 instance installed on the same serverbox. Thing is i can import/export my other DB-s, only this one seems to have a problem. –  Agony Aug 5 '12 at 12:22
1  
Columns have collations associated with them -- changing the collation at a higher-up level only sets the default for new objects, it doesn't change existing objects. I'm pretty sure the columns still have different collations, and that's the problem. –  Jon Seigel Aug 5 '12 at 15:25
show 3 more comments

1 Answer 1

Problem can be in field level as it was for me in my case in source database a field in a table had a differnt collation in a varchar datatype

if you choose < database default> for collation property of the fields the problem may be solved

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.