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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-11-07 : 05:46:01
|
| My ssis package exports .xls file data into a sql server table.The fields in the sql server table have to be nvarchar instead of varchar.If I use varchar then the ssis package gives an error about converting unicode to non-unicode...Another ssis package exports .csv data into the sqme sql server table as above.This time the sql server table fields have to be of type varchar because otherwise the ssis package gives an error about converting non-uniciode to unicode...I basically would like to have a sql server table with varchar fields and let these packages import into it.These packages may retrieve data from .csv or .xls.How can I resolve this?Thanks |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-07 : 10:09:19
|
| try using the "data conversion" data flow transformation |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-11-07 : 10:25:52
|
| Didn't realize one existed.Thanks |
|
|
|
Haplo
Starting Member
1 Post |
Posted - 2008-12-05 : 10:32:24
|
| What if you're still getting an error when trying to do the data type conversion? |
|
|
|
|
|
|
non-unicode to unicode error