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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply