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 |
|
athel
Starting Member
5 Posts |
 Posted - 2010-11-22 : 05:06:38
|
| Dear All,I have a sql server instance with server collation "Latin1_General_CI_AS" which code page is 1252.Now I restored a database on this instance with collation "SQL_Latin1_General_CP1250_CI_AS" which code page is 1250 as you can see. the problem is when I use SSIS to get the data from my database on this server, the codepage of these data out are always 1252. it should be 1250, doesn't it? anyone can help? thanks very much.Dream High, Work Hard! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 05:41:40
|
| Have a look at the import using the advanced editor. THat will show what the datatypes are and allow you to change them.You're right it should get the codepage from the column rather than the server and I'm a bit surprised that it doesn't.Note - having a database with a different collation from the server is going to cause a lot of issues. You have to be careful about the temp table character column definitions for instance and comparing data between databases will probably need a cast.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
athel
Starting Member
5 Posts |
Posted - 2010-11-22 : 06:14:50
|
| I use a lookup component and made the default pagecode equals to "1250". in the advance view, the ReferenceMetadata property shows me the codepage still is 1252 and the mapping still can not be made. and if I try to change the pagecode in the output property, it showed me "Property Value is not valid".any ideas about this?Dream High, Work Hard! |
|
|
|
athel
Starting Member
5 Posts |
Posted - 2010-11-24 : 22:52:36
|
| I got another weird problem.there some accountno in my table like this: "B0112458550L&%*=", they are generated from other placenow I tried to lookup these accountno using lookup component, and some of them can not match(random), but I can get them using sql statement like this: "select * from table where accountno='B0112458550L&%*='"but the lookup component cannot find it. what's wrong with SSIS package?=====================================================================Dream High, Work Hard! |
|
|
|
|
|
|
Different codepage between server and database