Hi Guys,
Here i come up with new question/issue in SSIS.
I am preparing SSIS package which will get data from Stored Procedure and export it into Excel. For exporting it, i am using Excel destination component.
Before Excel Destination component, i have added Data Conversion component.
What i observed is, when check my generated excel, in each columns, including headers have single quote(') as a prefix. When i double click on column of that excel, only that time that quote will apear. Do we have anything to not include such thing?
Submit an article or tip