I have a variable at the Package level MaxDate with string datatype in the expression of variable I am getting Max date from Time dimension @Maxdate =select max(date) from dimtime Now I am using this variable in derived column transformation like this rmrsentout < (DT_DBTIMESTAMP)" 1899-12-31" || rmrsentout > (DT_DBTIMESTAMP) @[User::Maxdate] ? (DT_DBTIMESTAMP)"1899-12-31" : rmrsentout [Derived Column [10059]] Error: Error code 0x80020005 occurred attempting to convert from data type DT_WSTR to data type DT_DBTIMESTAMP. but I have hardcoded a value like rmrsentout < (DT_DBTIMESTAMP)" 1899-12-31" || rmrsentout > (DT_DBTIMESTAMP) "2200-12-31 "? (DT_DBTIMESTAMP)"1899-12-31" : rmrsentout it works I dont understand why its giving error with the variable arun

String DataType I Can't use datetime because I am giving expression select max(date) from dimtime arun

Yes Evaluate as Expression property is True I dont undertsand "use the Query in OLEDB source" ?arun