October 9, 2014 at 4:25 pm
When exporting data from SQL to excel using SSIS ( used data conversion before exporting to excel destination), it is inserting single quote in front of each character in excel.
How to remove this single quote inside SSIS?
October 10, 2014 at 12:39 am
Is the single quote present right before you sent the data to the Excel destination?
If yes, remove it using a derived column.
If no, this means Excel has put it there itself to indicate the data are strings. This is common when you are putting numbers in a text column.
ps: why didn't you post this in an SSIS forum?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 7:49 am
Single quote is after exported to excel.
So how do I remove this?
October 10, 2014 at 7:54 am
What's the Excel version?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 9:30 am
Microsoft excel 97-2003
October 11, 2014 at 2:26 am
Pritz (10/10/2014)
Microsoft excel 97-2003
I've read somewhere that the ACE OLEDB driver has less issues with this. Try using that one instead. Not sure if it works with 97-2003, maybe you need to change version number in connection string.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 11, 2014 at 10:21 am
Destination is excel, how will we able to use ace oldb, can you please explain?
October 13, 2014 at 12:39 am
Pritz (10/11/2014)
Destination is excel, how will we able to use ace oldb, can you please explain?
This blog post might have some useful information:
SSIS Reading Excel (xls) data in 64 bit mode
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply