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 |
|
paull
Yak Posting Veteran
50 Posts |
 Posted - 2010-07-29 : 10:38:31
|
| Hi allI am doing a simple package that loops through a folder and picks up all .csv type files and loads them to an existing table in SQL Express.I have just started learning about SSIS so I am doing each step individually and I am now stuck when I try to do the Data Flow Task. I get a whole list of error messages telling me that it cannot convert between Unicode and non Unicode data types.I have tried changing the destination column type, and tried adding a data convert transformation with no avail.If there is a simple rule I could follow, that would be fantastic!Many thanks in advance! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-29 : 13:55:31
|
| making target column unicode should work. so too should the data conversion task in the data flow. what data types are u using? |
 |
|
|
|
|
|
Unicode data types