none
ssis 2010 to excel 2013, cell format issue RRS feed

  • Question

  • 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

    Thursday, October 17, 2019 2:19 PM

All replies

  • billybobsonic,

    Sorry but you have posted to a forum that deals exclusively with questions/issues about customizing and programming for Microsoft Project, a project management application. I suggest you re-post to the following forum:

    https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

    John

    Thursday, October 17, 2019 2:26 PM