sqlcurious
asked on
Derived column expression meaning in ssis
Please let me know the actual purpose, I am trying to understand from an existing package
1)ISNULL(ESN) ? (DT_WSTR,50)"Accessories" : "Phone"
2)(DT_DBTimeStamp)((SUBSTR ING((DT_WS TR,8)[Rece ive Date],5,2) + "-" + SUBSTRING((DT_WSTR,8)[Rece ive Date],7,2) + "-" + SUBSTRING((DT_WSTR,8)[Rece ive Date],1,4)))
3)ISNULL(ESN) ? REPLACE(SKU,SUBSTRING(SKU, 1,FINDSTRI NG(SKU," ",1)),"") : SKU
1)ISNULL(ESN) ? (DT_WSTR,50)"Accessories" : "Phone"
2)(DT_DBTimeStamp)((SUBSTR
3)ISNULL(ESN) ? REPLACE(SKU,SUBSTRING(SKU,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER