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

 , 
 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |