September 14, 2006 at 3:52 am
Hello,
I have a DTS that brings data from Oracle View to SQL 2000 table.
The problem is with text fields. For instance if i have a field with this data:
- Decoração
In Sql it will appear like this:
-Decoração
Anyone can help me?
Thank You,
Sérgio
September 15, 2006 at 2:54 am
Hi
Not sure if I am sending you down the wrong route but could it not to be with the different collations on the Database's
Michael
September 15, 2006 at 4:29 am
Hi,
I have no idea. I don't have acess to Oracle database. Are you talking about oracle or sql collation?
September 15, 2006 at 5:37 am
Hi
Here is two things I would try...
1. Try import the data into a text file....Then into the table.. Check what it looks like in the text file and then check it in the table..
2. Find out collation settings are on the Oracle database...Then you can change the collation on the column level in SQL 2000 see if that sorts it out.
Mike
September 15, 2006 at 9:50 am
Are you sure the field in SQL-Server is defined as "ntext" or "nvarchar", it looks like it is taking some characters as 2 which is what happens with the field defined as "text" or "varchar"
Mike
September 15, 2006 at 3:14 pm
It looks like your codepages are different between the Oralce and SQL servers. Make sure the codepages match to get the correct data. If you can't change the codepage on the Oracle server, you can set the default codepage in the properties of the data flow object in business intelligence development studio. Also, set the property "always use default codepage" to True. That should fix the problem.
Joshua Perry
http://www.greenarrow.net
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply