SSIS Extracting Data from OLE DB Data Source to Excel

  • 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

  • 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

  • ... 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