Post reply

Date column Error

  • April 15, 2009 at 9:49 pm

    #384367

    Hi All,

    I have a date column in Excel sheet. if the user type a varchar or numeric data for 8 to 10 lines then type date values - in my source it is coming as NULL values. actual date values are not coming.

    how to solve this.

    Thanks,

    Regards,

    Viji

  • April 15, 2009 at 9:58 pm

    #978587

    Have you trying using the Data Conversion task in the Data Flow tab. Should be up to the task.

    Fraggle

  • April 16, 2009 at 5:26 am

    #978715

    In properties on the excel connection manager.

    Check the connection string. Make sure IMEX=1 in the extended properties.

    i.e

    Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

    hope that helps

  • April 16, 2009 at 8:39 pm

    #979388

    Hi,

    Thanks a lot. setting extended properties to IMEX=1 works, provided when i set all my excel columns meta data to text.

    regards

    viji

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply