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 |
|
Teachme
Starting Member
45 Posts |
 Posted - 2006-10-10 : 00:29:08
|
| i am loading data from sql server to oracle. i have one field name 'zipcode' in sql server table and its data type is varchar(16). i have the same field in oracle with datatype 'Interval day to second' there is a value '40014 JYVSKYLN' which are actually Accent letters in zipcode field in sql server table. But when i copy paste it here letters do not appear here but letter looks like 'A' with dot(.) on the head. Because of this latters in zipcode, the rows are keep failing to be loaded into oracle. I just need help with getting this field into oracle '40014 JYVSKYLN'. Is there any function that would convert accent value into english or any other alternative such as vb script to resolve this issue? Any kind of help would be appreciated. Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-10 : 00:55:17
|
| Are you using UNICODE?Peter LarssonHelsingborg, Sweden |
 |
|
|
Teachme
Starting Member
45 Posts |
Posted - 2006-10-10 : 09:53:23
|
| data is coming from application which is used world wide. and datatype of zicode field is varchar(16). so i don't think that unicode is being used |
|
|
|
|
|
|
Trasformation error in DTS