+ Start a Discussion

.NET managed provider and batch insert


Does anyone know the best way to use the .NET managed provider to bulk insert into salesforce?

I am trying to pull data from SQL server, and then add in batch to Salesforce.


Hi Darrell,

Right now the managed provider does not do batching on Inserts. It is a feature that Karl and I are scheduled to put into the next release (the 2.0 .NET provider).

In the meantime, why not use the batch insert facilities of DBAmp/Pro ? Look in you doc under the 'Bulk Operations with DBAmp' chapter for info on the SF_BulkOps stored proc. It can batch insert, update and delete directly from an SQL Server table.

Bill Emerson