I have problems when exporting data into Excel file from SSIS. It all works fine with numeric columns but an apostrophe is attached at the beginning of each text cell. I tried using derived columns and data conversions but it didn't work. It seems to me that problem is in 'excel destination' task... I saw many people had this kind of problems too... Is there any solution possible?
Thanks.
I too am experiencing this problem. Have you discovered a solution?|||Export that data to a CSV file from Excel and you'll find that the tick does not exist. I believe you'll find that the 'tick' is just an Excel display feature. It's not really part of the data.|||This inconvenient behavior of the Excel driver is mentioned in the BOL topic on the Excel Destination, and appears to be an attempt by the driver to force the output to be treated as string data (since the destination column does not really have a built-in data type), using the convention of the single quote that dates from Lotus 1-2-3.
-Doug
No comments:
Post a Comment