Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Srain
Starting Member
23 Posts |
 Posted - 2009-04-21 : 05:05:09
|
| Hi, I am getting the error "The column "XXX" cannot be processed because more than one code page (1250 and 1252) are specified for it" when trying to import data from one table to other across servers using SQL server 2005 DB in the SSIS package. Please suggest what need to be done. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-04-21 : 05:40:52
|
| This may be useful for you:http://msdn.microsoft.com/en-us/library/ms190657(SQL.90).aspxYou are trying to copy data between 2 different collations.The other thing to do is look up COLLATE in BOL (Books Online). |
 |
|
|
Srain
Starting Member
23 Posts |
Posted - 2009-04-21 : 06:20:01
|
This helps. Many Thanks.quote:
Originally posted by RickD
This may be useful for you:http://msdn.microsoft.com/en-us/library/ms190657(SQL.90).aspxYou are trying to copy data between 2 different collations.The other thing to do is look up COLLATE in BOL (Books Online).
|
|
|
|
|
|
|
code page error