That's exactly where the problem begins. For the variable I had assigned the value as 'Select logindate from Azuredb' and then used that variable in Oracle query in the look...

I use the SELECT  ID , Dep ID, Start date , End date, Fund Code FROM ORACLETABLE WHERE (TO_DATE(?, 'YYYY-MM-DD') BETWEEN OracleTable.StartDate AND OracleTable.EndDate in the LOOK UP transformation.

If you...

Thank you for the response, but that is using Execute Sql task not the Look up transformation ? May be I was not clear, here is the situation - The...

Thank you for the response, but that is using Execute Sql task not the Look up transformation ? May be I was not clear, here is the situation - The...