Try using an expression on the source component to construct the SQL statement instead of using a parametrized query.
Something like this:
"SELECT ColA, ColB, ColC
FROM TABLE_DTL
WHERE LastModifiedNumericDate > " + (DT_STR,10,1252) @[User::MyVariable]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP