Post reply

Numeric Empty column in SSIS

  • January 26, 2009 at 4:39 am

    #199069

    Hi,

    how to identify a excel numeric column is empty or not using SSIS 2008?

    Thanks,

    Regards

    Viji

  • January 26, 2009 at 11:03 pm

    #933000

    using isnull function

  • January 27, 2009 at 8:30 pm

    #933600

    Hi,

    ISNULL function works for character.

    numeric fields which is blank are not thrown into error output.

    thanks,

    regards

    viji

  • January 29, 2009 at 4:25 am

    #934506

    LEN(field)>0

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

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

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