Link to home
Start Free TrialLog in
Avatar of Basssque
Basssque

asked on

SSIS/SSDT Derived Table Syntax

Is it possible to insert the field results into this statement?
I want to return the information from the matching field after my statement below

This is what I have now
[JOBS_CONTRACT_END_DATE] < (DT_WSTR,10)(DT_DBDATE)(GETDATE()) ? "ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y)" [JOBS_CONTRACT_END_DATE]
It throws "ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y)" in replacement for the value if the value in the [JOBS_CONTRACT_END_DATE] is less than the current date.

I want to add the actual value to the end of my string so it returns
ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y) [JOBS_CONTRACT_END_DATE]

[JOBS_CONTRACT_END_DATE] would be a date formatted as yyyy-mm-dd

Is that Possible?
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial