Hello Everyone,
I am trying to find a way to remove Leading apostrophe present in excel when data is exported from SQL Into EXCEL using SSIS
There is a script task which generates the excel file on the fly and loads the data into the file. Though there are no issues with the data, the excel automatically adds the apostrophe in the begging of the cell. I also observed that the issue is only observed in .xls file. I have tried researching this topic on the web but could not find any solution.
Is there any way we could over come this issue?
Your help would be appreciated