function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dgrissendgrissen 

.NET managed provider and batch insert

Hi,

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.

Thanks,

Darrell
qmanqman
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