Apex Code Development You need to sign in to do that
Don't have an account?
dgrissen .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
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
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