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 |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-03-12 : 04:30:47
|
| I receive an error Source: Data Flow Task OLE DB Source [1] Description: The column "FALNR" cannot be processed because more than one code page (1252 and 1255) are specified for it. End Error Error The task is very simple - table A (FALNR varchar(10)) is transfered to table B (FALNR varchar(10))It works on DEV computer, and the error is received after deploying to PROD.I changed "AlwaysUseDefaultCodePage" to True, that helped in similar situations, but now it doesn't work. Any help is welcome |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2009-03-12 : 10:00:53
|
| Compare the collation on the DEV and PROD environments. The code page error is related to collation.hth,Tim---------------------Tim Mitchellwww.BucketOfBits.com |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-03-12 : 10:09:03
|
| I was told they are fully compartible and cannot be the problem -on PROD - SQL_LATIN1_General_CP1255_CI_AS on DEV - Hebrew_CI_AS |
|
|
|
|
|
|
Error processing more than one code page