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.
Bulk Load to SQL Server(ODBC)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 32
- Joined: Tue Dec 13, 2011 7:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: