Post reply

How to use isnull for a datetime column

  • December 15, 2010 at 3:45 pm

    #149519

    hello,

    I need to use isnull on a column in precedence constraints with datatype datetime,

    when isnull is false there is no problem package is running fine but

    even though isnull is true it is taking some default date running in different

    condition path.

    Can any one please tell me how to test this null values in datetime column

    using isnull???????

    thanks

    Sasi.

  • December 15, 2010 at 11:39 pm

    #1263311

    I am not clear with your question.

    Anyways ISNULL('"Column_name")?"some_value_if true":"else_value_if_false"

    Hope this helps!!

    Raunak J

  • December 20, 2010 at 4:19 am

    #1264558

    Hi Sasi

    In SSIS if the datetime field is null,it will take a default date value

    So in precedence constraint u need to compare the date value with null or blanck or space or with the default date value what it is returning

    Hope this will help

    Incase any query let me know

    Rashmi

  • December 20, 2010 at 8:02 am

    #1264641

    hello,

    thanks for help, I did the same

    Sasi.

    rashmiptl22 (12/20/2010)

    Hi Sasi

    In SSIS if the datetime field is null,it will take a default date value

    So in precedence constraint u need to compare the date value with null or blanck or space or with the default date value what it is returning

    Hope this will help

    Incase any query let me know

    Rashmi

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

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