alcsoft
asked on
SSIS Derived Column Expression
Hi,
I am trying to run this inside the SSIS Derived Column Expression, but it doesn't work.
DATEDIFF("d", [date1],[date2]) > 14 ? "(Start " + (DT_WSTR) DATEDIFF("d", [date1],[date2])+ " End)" : NULL(DT_WSTR,10)
Can you please tell me what's wrong?
I am trying to run this inside the SSIS Derived Column Expression, but it doesn't work.
DATEDIFF("d", [date1],[date2]) > 14 ? "(Start " + (DT_WSTR) DATEDIFF("d", [date1],[date2])+ " End)" : NULL(DT_WSTR,10)
Can you please tell me what's wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER