Hi I'm trying to import data from a CSV file into a SQL Server 2022 table.
My PDI 9.3 transformation works without error using a CSV file import and Table output action. Using the same settings in HOP 2.5.0 (2023-06-08 07.58.35) I get these errors and no data imports: 2023/09/25 09:43:59 - Insert products.0 - Error setting value #1 [String(75)<binary-string>] on prepared statement 2023/09/25 09:43:59 - Insert products.0 - The index 1 is out of range. 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:383) 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.processRow(TableOutput.java:117) 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) 2023/09/25 09:43:59 - Insert products.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2023/09/25 09:43:59 - Insert products.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: How do I resolve this issue? Thanks Rob
