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.