Home Forums SQL Server 2005 SQL Server 2005 Integration Services To insert varchar records in datetime field RE: To insert varchar records in datetime field

  • October 11, 2012 at 1:10 am

    #1547903

    sqlstud (10/10/2012)

    Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your datetime datatype (which I strongly recommend) then you probably need to make that NULL. If you want to maintain the data exactly as it is excel you will have to change to a varchar column.

    Thanks Sean..

    I have changed the datatype to Varchar....

    Please find the attachement.

    While make a preview in OLEDB Source the data in the date column is displayed as NULL. But in excel sheet, it is "DECLINED".

    Could you please give me the solution?

    Regards

    SqlStud

    I am with Sean - it's 100 times better to keep your dates in a datetime column and do something else with the DECLINED info - perhaps create another column to hold 'status', or whatever, and use that.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.