| Steen Persson (DK) 2006-03-31, 9:23 am |
| Hi
I'm trying to design a fairly simple SSIS package, that just selects
some data from a database and then export these data to an Excel sheet.
When I run/debug the package, it fails with a
"Error at Data Flow Task [Excel Destination [1741]]: Column "xxxx"
cannot convert between unicode and non-unicode string data types."
It does that for all the string columns I have in the export.
In the package, I have an OLE DB Source with a SQL query to find the
data. I then have a Data Flow Task to an Excel Destination.
I've checked the Input/Output properties for the OLE DB source, and in
here all the columns are of type "String [DT_STR]". In the Data Flow
Metadata view, it also reports the columns as being DT_STR.
If I then look at the Excel Destination Input/Output columns, the
datatype of the columns in "Excel Destination Input - > External
Columns" are Unicode string[DT_WSTR] where the type in "Excel
Destination Input -> Input Columns" are of type DT_STR.
I have tried to change the External COlumns definition to "String
[DT_STR] but it doesn't seems to make any difference. Also when I go
back to check it, it has set back the type to Unikcode....
How do others do this simple task to export some data to Excel without
running into this problem? I have tried everything I can think of, but
with no luck.
Regards
Steen
|