I am sure everyone has this problem before. I got an error trying to copy tables from Oracle to MSSQL using tMap and I encounter the Date type transformation since MSSQL does not have Date type. It uses datetime...I got this error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Column, parameter, or variable #6: Cannot find data type DATE.
How do you change this?
Thank you
