Exception in component tMSSqlInput_10 com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from smalldatetime to INTEGER is unsupported.

[Anonymous]

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.

kindly assist

[fdenis]

Hi,
from mssql convert your date as text.
in postgres convert text as date.
Regards,