Post reply

NULL Date Value to Conditional Split in DTS Package

  • June 12, 2013 at 12:20 pm

    #279107

    Hi,

    I am trying to set up a condition so that all Records with NULL Dates are separated. The Data Type of incoming field is DT_DBTimeStamp.

    So, how to use the 'Condition Expression' ??

    My_Date == NULL(DT_DBDate,My_Date)

  • June 13, 2013 at 11:43 pm

    #1623960

    This is what you can do the solve this.

    1. Add a Conditional Split Task

    2. in the Conditional Split Task editor window drag the My_Date window to order/outputname row.

    3. In the Outputname write 'NullValuesDate' and in condition box write ISNULL(My_Date)

    4. To pass the data from Conditional Spilt Task to another task drag the Output name 'NullValuesDate'.

    Vikash Kumar Singh || www.singhvikash.in

Viewing 2 posts - 1 through 1 (of 1 total)

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