Parallel Bulk Copy Syntax

Use this syntax for parallel bulk copy, when using several simultaneous sessions.

bcp table_name[:partition_number | partrition_name] in file_name
-Pmypassword

table_name – is the name of the table into which you are copying the data.
partition_name – is the name of the partition into which you are copying.
file_name – is the host file that contains the data.
mypassword – is your password.

Alternatively, you can execute parallel bulk copy using a multithreaded version of bcp:

(UNIX) Perform this using the bcp_r command:

bcp_r database_name..table_name partition partition_number1  
[,  partition_number2 ...] in file_name1 [,file_name2 ....] 
-U[username] -P[password] -S[servername]

(Windows) The standard bcp command is capable of paralled execution:

bcp database_name..table_name partition partition_number1  
[,  partition_number2 ...] in file_name1 [,file_name2 ....] 
-U[username] -P[password] -S[servername]