Bulk Load to SQL Server(ODBC)

[adityavinay]

Hi All,
I am looking for some suggestions on doing a bulk load to SQL Server. I did searched this forum and found few results , most of them say the same what i am implementing.

I used DRS Connector stage(bulk insert) - tweaked record count multiple times (25 - 100000)
ODBC connector stage - tweaked record count and Array size.

we are using Data Direct 6.0 for ODBC drivers and enabled Bulk load in ODBC DSN.

Here are the DSN details
EnableBulkLoad=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=0

I ran this job on 2 node but the number of rows/sec is close to 1200..
Could some one please throw some light on how to get this increased?... Not sure what i am missing here

Thanks in advance,

Aditya.

[ray.wurlod]

The delay here may be the network between your DataStage engine and the SQL Server machine.