Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NULL Date Value to Conditional Split in DTS Package Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 12:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 11:19 AM
Points: 2, Visits: 6
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)

Post #1462772
Posted Thursday, June 13, 2013 11:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:15 AM
Points: 79, Visits: 243
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
Post #1463392
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse