>>> Error setting value #1 [String(75)<binary-string>] on prepared statement Your CSV input probably has the "lazy conversion" checked. Unchecking that should resolve the issue.
Regards, Bart On Sun, Sep 24, 2023 at 11:14 PM Rob Burgess <[email protected]> wrote: > 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 >
