Well the files I'm loading are numbered, i.e. source001, source002, etc. Thus my copy statement readsknicely87 wrote:Since you are using a shared directory maybe you need to have unique file names for each node?
Example:
Copy myTable From '/myDirectory/*' On Any Node
Rejected Data '/rejects_directory/node1.rej' On node_1, '/rejects_directory/node2.rej' on node_2
Exceptions '/exceptions_directory/node1.exp' On node_1, '/exceptions_directory/node2.exp' on node_2
Code: Select all
Copy myTable From '/myDirectory/source*' On Any Node