tDBBulkExec (PostgreSQL) error opening file

Igor_V — Sat, 16 Nov 2024 00:01:54 GMT

Hi all!!

I try to use tDBBulkExec (PostgreSQL).

In the field "FieldName", I specify an existing file just created with the components tDBImput+tFileOutputDelimited based on the same table, but when I run job I get an error:

"ERROR: could not open file "C:/fields_mark_insert.csv"

for reading: No such file or directory

Prompt: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility

such as psql's \copy."

What could be the problem?

Re: tDBBulkExec (PostgreSQL) error opening file

manodwhb — Mon, 21 Jun 2021 10:38:06 GMT

@Grapeus Grapeus , you need to have the file in PostgreSQL db server.

Name of the file to be loaded.

Warning:

This file is located on the machine specified by the URI in the Host field so it should be on the same machine as the database server.

check the below link.

https://help.talend.com/r/YxpC8~71OVAWmBgQIAFNtQ/8bR0shLTtmEizKAeerd1VA

Thanks,

Manohar

topic Re: tDBBulkExec (PostgreSQL) error opening file in Talend Studio

tDBBulkExec (PostgreSQL) error opening file

Re: tDBBulkExec (PostgreSQL) error opening file