Hi team
I am using ssis 2010 to excel 2013, I am experiencing a cell format issue
I have a date, I have even used a data conversion to make sure it is a date, but when the data enters the excel cell its
'01/01/2019
I don't know why it is adding a ' symbol before the date
also I have a number 7 coming across, and the cell is formatted to general before it reaches excel , but when shown in excel it is 7.0 as cell has converted itself to text! I don't know why this keeps happening
please help