The Definitive Guide to Data Quality
Solved! Go to Solution.
Found this posted in a message from 2009...
"Files named in a COPY command are read or written directly by the server, not by the client application. Therefore, they must reside on or be accessible to the database server machine, not the client. They must be accessible to and readable or writable by the PostgreSQL user (the user ID the server runs as), not the client. COPY naming a file is only allowed to database superusers, since it allows reading or writing any file that the server has privileges to access. "
So to recap if you want to carry out a bulkexec on a remote database you must copy the file to the server hosting that database and then in the bulkexec component for the filename you must provide the path to the file as it appears on the server.