October 21, 2019 at 7:09 pm
i have a variable in my SSIS package called
Name datatype value expression
lastupdated datetime 12/30/1899 NULL(DT_DATE)
My package has logic based on this date.
if @[User::lastupdated] == (DT_Date) "12/30/1899" it goes to leftflow
if @[User::lastupdated] ! = (DT_Date) "12/30/1899" it goes to rightflow.
i am using this same variable form my dtsconfig file and the value i kept as 2019-01-01.
when i run the package as the value in this variable from config file is 2019-01-01, it should go to right flow. but it keeps on going to left flow.
suppose if i remove NULL(DT_DATE) in the expression then it goes to right flow. not sure what is the issue here.
October 21, 2019 at 7:40 pm
Your expression NULL(DT_DATE) is returning the 1899 date always. You cannot change it, unless you change the expression to return something else.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply