It sounds like you're close. Please post the expression you're trying to use as well as the exact error message you get when it fails to evaluate.
If you don't mind attaching your SSIS pkg to the thread I'll take a look at it on my side. Obfuscate names as needed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato