Migrating MySQL table to SQL Server

[FGuijarro]

Hi,

I am trying to copy a table from MySQL to SQLServer

Design is as follows:

tDBInput (MySQL) -- tMap -- tDBOutput (SQLServer, JTDS)

The structure of the input table is:

"CREATE TABLE IF NOT EXISTS `operador_modelo_negocio` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,

 `

fecha_inserccion timestamp

`

NOT NULL,

 `cliente` bigint(20) DEFAULT '0',

 `modelo_negocio` int(2) DEFAULT '3',

 `dto_operador` double DEFAULT '0',

 PRIMARY KEY (`id`),

 KEY `cliente` (`cliente`),

 KEY `modelo_negocio` (`modelo_negocio`)

);"

I´m getting the error message:

Picked up _JAVA_OPTIONS: -Xms1024m -Xmx8196m

[statistics] connecting to socket on port 4068

[statistics] connected

Exception in component tDBOutput_1 (MySQL_SQLServer_DBServerMovil)

java.sql.SQLException: Only dates in the AD era are accepted.

at net.sourceforge.jtds.jdbc.DateTime.<init>(DateTime.java:104)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:665)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setTimestamp(JtdsPreparedStatement.java:1100)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.tDBInput_1Process(MySQL_SQLServer_DBServerMovil.java:1195)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.runJobInTOS(MySQL_SQLServer_DBServerMovil.java:1728)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.main(MySQL_SQLServer_DBServerMovil.java:1577)

[statistics] disconnected

Job MySQL_SQLServer_DBServerMovil ended at 10:10 10/12/2020. [exit code = 1]

Any help with this error, please???

[root]

I think you have an incorrectly formatted date in the Input data. Its not the best approach, but, I will change the schema of the IP component to varchar and then, in tMap, change it to appropriate format for MSSQL. HTH.