Clever Geek Handbook

Combining two date fields for conditional separation

I am new to SSIS, so please excuse me if you need to clarify my problem.

We have 2 date columns, Release Date

and Approved Draft Release Date

.

Currently, when a date is manually entered in the Release Date column field, the SSIS package populates the Approved Draft Release Date column field with the same date. However, when the Release Date is changed and the package is relaunched, the release date of the approved project was also changed.

We created an additional data flow task in the package to change the release date without overwriting the approved project release date. However, the condition I included in the conditional split doesn't work.

NULL([Release Date]), > ([Approved Draft Release Date])

I hope someone please take a look at this state and let me know what we are missing.

Thank you so much for any suggestions you can provide.

+3


source to share


1 answer 


NULL([Release Date]), > ([Approved Draft Release Date])

is not a valid expression. It looks like you need the following.



ISNULL([Release Date]) == False && [Release Date] > [Approved Draft Release Date]

Note that NULL(typedesc)

Returns a null value of the requested data type. To check if a column is null you can use the functionISNULL()

+1


source






More articles:


All Articles