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 |
|
GregDDDD
Posting Yak Master
120 Posts |
 Posted - 2011-08-31 : 14:55:19
|
| I'm trying to do a flat-file import to a SQL Server 2005 table. It fails with the error below. The column in the existing table is nvarchar(256). When setting up the flat-file in the wizard I have the choices of string, text stream, unicode string, and unicode text stream for data types, but none work. Any help is appreciated.GregError 0xc02020ed: Data Flow Task: Columns "Column 4" and "Description" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard) |
|
|
GregDDDD
Posting Yak Master
120 Posts |
|
|
|
|
|
Convert between unicode and non-unicode