Bulk Load to SQL Server(ODBC)
Posted: Wed May 01, 2013 8:57 am
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.
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.