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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-07-09 : 08:38:49
|
| Hi Guys, I am having an awful time trying to import a file, any help would be greatly appreciated. I am receiving the error msg: Column Lname and LName cannot be converted between UNICODE and non-unicode string data types.The input file is being pulled from an FTP site the field LName is defined as string. The error msg is being applied to all fields, all fields are defined as string.What must I do to correct the field conversion problem?Thank you,Trudye |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-09 : 10:14:18
|
| I know this problem and i had no time to search for the right solution.My workaround: (look into an automatic generated package)- Take the Management Studio and connect to your server- Right click the destination database and choose Task->Import Data- Follow the Wizardsteps - Choose to Save as package and not to run immediately- Save the package in the filesystem- Open the package and look there how to get your data convertedGreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2008-07-09 : 12:10:34
|
| Thanks WebFred for responding. I finally changed the nvarchar fields to varchar and that seemed to solve the problem. Now I have a whole new set of problems with my *.fmt file. Thanks again,Trudye |
|
|
|
|
|
|
Error in Unicode & non Unicode conversion