I am trying to build the below sql expression to store it in a variable but
it is giving me cast error for the operands.

"select * from OrclTbl where load_date <"
+(DT_DBTIMESTAMP)@[User::varFromDate]

I even tried the below still it gives me the same error
"select * from OrclTbl where load_date <"
+ getdate()

Try the (DT_DBDATE) conversion.

Do you have a representative value in the varFromDate when you go to build
your expression? You will need something in the variable during desing time,
otherwise the SQL Syntax checker might fail.

One last question: Where are you building this expression? In a Data Flow
Source Adapter? Can you give us an overall view of your package design?
(Control Flow elements and Data Flow transforms, etc)

Todd C


"Usha" wrote: