NULL Date Value to Conditional Split in DTS Package

• niladri_chatterjee

  SSC Veteran

  Points: 254

  More actions

  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)

• Vikash Kumar Singh

  SSC Eights!

  Points: 974

  More actions

  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