Hi Im trying to load data from mssql 2008 to Postgres.
mssql source has a column of data type smalldatetime and im mapping it to timestamp in postgres.
The below error is received,
Exception in component tMSSqlInput_10
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from smalldatetime to INTEGER is unsupported.
Tag as "solved" for others! Kudos to thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema