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

Anonymous — Tue, 30 Oct 2018 08:32:04 GMT

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

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

fdenis — Tue, 30 Oct 2018 13:34:55 GMT

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