I tried to dts a table to an excel file. The data types of all the columns in the table are varchar. I also want the data in the destination excel file to be text, so I didn't change the data format in the dts package. But after ran the dts, every value of every cell of the excel file has a single quote before it (not in the cell itself, but in the value shown space right below the toolbar). I tried to dts the table into a excel template which I predefined all cells to be text type. But some of the columns do not have the single quote anymore, while others still keep them. Since the other system that going to process the excel file does not expect the single quote, the process always fails.

Would anybody tell me how to get rid of the single quote?
Thanks a lot.

Qing