parallel data load using bcp

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vivek T S (VivekTS_at_discussions.microsoft.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 01:43:01 -0700

i did a parallel load into a single table using bcp from 2 machines. as
suggested in the docs i used the TABLOCK hint. as a result i observed that:
a) first all the data from machine1 is inserted. When this is finished then
all the data from machine2 is inserted
b) i don't see any parallelism in this . Is there any other way of acheiving
true paralellism.

NOTE: SQL Server is running on a dual cpu machine 

-- 
Vivek T S
Member Technical Staff (Inucom)