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.

 All Forums
 General SQL Server Forums
 Script Library
 IS unicode format

Author  Topic 

Freddie
Starting Member

29 Posts

Posted - 2006-08-04 : 12:14:23
Hello everyone:

I created a package in IS. My source file is an excel file and my destination file is a sql server 2000 table. when i ran the package the following error was displayed:

"Cannot map a unicode format to a non-unicode format".

My sql table is non-unicode. I modified my text field to be unicode and it ran. I have many tables and do not wish to modify them manually. Is there a way around this problem??

Much appreciated!!

F.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-04 : 13:58:38
This forum is not for questions.


Script Library Forum description:
"This section is for any originally written scripts you'd like to share with the group."




CODO ERGO SUM
Go to Top of Page
   

- Advertisement -