473,327 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Unicode Conversion

I have created an SSIS (think that is what DTS is called now) package
to run on a SQL 2005 server. It's job is to connect to a SQL 2000
server, execute a stored procedure, and insert the returned data into a
table of the '05 box.

In both tables (source and destination), the string columns are defined
as VARCHAR. But when I run my package, i get back the following error
'Column "xxx" cannot convert between unicode and non-unicode string
data types'.

While they DO have different collation values --
SQL_Latin1_General_CP1_CI_AS on sql 2000 database and
Latin1_General_CI_AI on the sql 2005 database (columns are set to use
database default value) -- it was my understanding (or
mis-understanding) that collation values do not affect unicode issues.

Is there anything I can look at to further find the problem or even fix
it?

Thanks,

Jan 9 '06 #1
1 6417
(Ja*******@hotmail.com) writes:
I have created an SSIS (think that is what DTS is called now) package
to run on a SQL 2005 server. It's job is to connect to a SQL 2000
server, execute a stored procedure, and insert the returned data into a
table of the '05 box.

In both tables (source and destination), the string columns are defined
as VARCHAR. But when I run my package, i get back the following error
'Column "xxx" cannot convert between unicode and non-unicode string
data types'.

While they DO have different collation values --
SQL_Latin1_General_CP1_CI_AS on sql 2000 database and
Latin1_General_CI_AI on the sql 2005 database (columns are set to use
database default value) -- it was my understanding (or
mis-understanding) that collation values do not affect unicode issues.

Is there anything I can look at to further find the problem or even fix
it?


Beside testing the Copy Database Wizard, I have not used SSIS (or DTS),
so I don't know exactly what is going on. But it looks a little corny
to me. Had the collations had different code pages, it would have been
another matter, as then there could be characters in the source column
that could not be represented in the target colunm.

Had I known SSIS better, I might have been confident to recommend you
to file a bug on http://lab.msdn.microsoft.com/ProductFeedback/. But
now I would suggest that you should ask the people in
microsoft.public.sqlserver.integrationsvcs first.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 9 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

23
by: Hallvard B Furuseth | last post by:
Has someone got a Python routine or module which converts Unicode strings to lowercase (or uppercase)? What I actually need to do is to compare a number of strings in a case-insensitive manner,...
22
by: Keith MacDonald | last post by:
Hello, Is there a portable (at least for VC.Net and g++) method to convert text between wchar_t and char, using the standard library? I may have missed something obvious, but the section on...
0
by: Jonathan | last post by:
I have a unicode database and I basically wish to publish out certain data (via views) from it to a non unicode database. Unfortunately we can not change the type of either of the databases due to...
6
by: New MSSQL DBA | last post by:
Hi all, we are now planning to upgrade our application from a non-unicode version to a unicode version. The application's backend is a SQL Server 2000 SP3. The concern is, existing business...
4
by: djake | last post by:
How can I convert char in wchar_t? And how can I convert wchar_t in char? Thanks to anyone
10
by: Nikolay Petrov | last post by:
How can I convert DOS cyrillic text to Unicode
18
by: Ger | last post by:
I have not been able to find a simple, straight forward Unicode to ASCII string conversion function in VB.Net. Is that because such a function does not exists or do I overlook it? I found...
9
by: mistral | last post by:
Is there some Unicode converter to convert javascript to Unicode format? thanks mistral
13
by: gabor | last post by:
hi, from the documentation (http://docs.python.org/lib/os-file-dir.html) for os.listdir: "On Windows NT/2k/XP and Unix, if path is a Unicode object, the result will be a list of Unicode...
0
by: santhescript01 | last post by:
Unicode to non unicode conversion problem -------------------------------------------------------------------------------- Hi All, I am using C dll in macro which converts Unicode data to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.