I am trying to assign Date values from ESQL task to a date variable, it is getting executed without assigning any value to date variable
SELECT MAX(lastupdateddate) AS lastupdateddate,MAX(id) AS sourceseqid FROM Pat
it is taking some junk value as "12/30/1899" and null for sequence
ESQL (general)- >ResultSet - Single row
Connection type-> OLEDB
SQL Statement ->SELECT MAX(lastupdateddate) AS lastupdateddate,MAX(id) AS sourceseqid FROM Pat
ESQL (resultset) -> Result Name: lastupdateddate -Variable Name User::vLastUpdatedDate
Result Name: sourceseqid Variable name : User::vSourceSeqId
Any idea why it may be happening ? All the variable scope is at package level