INSERT activity in DATABASE ACTIVITIES package

Hello,

I have read the excel file as data table and trying to insert the whole data table into HSQLDB table using INSERT activity in Database activities package. I can able to insert the whole data table into HSQLDB table. But it inserts all the numeric values as blank values and string column values as NULL value. I am not sure whether it is a bug or the feature not supported by HSQLDB.

I used same flow for PostgresSQL DB, it works fine. Any idea on resolving this issue?

Note that the connections are fine. i am using ODBC data source. when i iterate each row in the data table and insert one by one row into HSQLDB table, it works.

Thanks!!!

Hi @Gopi_Arumugam

Could you maybe show a snippet of what works and what does not? It would help a little to understand the issue.