SSIS Lookup Transformation with Date values

 

When comparing Oracle dates to SQL Server I have found that it only works when the Oracle and SQL dates are strings.

Therefore in your Oracle query add a new column like this:

TO_CHAR(SYSDATE,'DD/MM/YYYY') as DATE_STRING

then in your SQL Server query add a new column:

CONVERT(VARCHAR(10), GETDATE(), 103) AS DATE_STRING

You can then map the columns in the Lookup Transform dialog.