tDBBulkExec (PostgreSQL) error opening file

[Igor_V]

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?

[manodwhb]

@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