March 14, 2011 at 2:46 pm
Hello,
When extracting data from an OLE DB Datasource to an Excel Spreadsheet, I get this error.
I have read a little about this error. However, I would rather not use the conversion tool as the data in the table does use unicode data types.
My workaround has been to extract to a flat file and import into Excel.
My question is: How does one force an OLE DB Datasource to extract data in a non-unicode format?
Thanks!
Michael
March 15, 2011 at 1:03 am
What is the error?
So the table uses unicode data types, but you want OLE DB to extract non-unicode data types?
Either set the data types in the advanced editor of the OLE DB Source or use the conversion component (it is there for a reason).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2011 at 7:39 am
... or use the conversion component (it is there for a reason).
Probably the better choice: using the data conversion component more clearly shows what's happening in the data flow (data conversion) and is more maintainable when someone else has to pick up the package at a later date, or if the data source and/or excel change sometime down the road, changing the metadata.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply