Hi Steve,

Yes, I know what you mean about the Bulk API - the CData driver uses it internally (and transparently) as well.

One thing that might not be...

I may be mistaken, but I believe that DBAmp allow you to replicate salesforce data to a local instance of SQL server, correct? Replication/sync is a different problem entirely....

Hi Mark,

I don't have performance metrics that I can share that would compare these SSIS components. That said, RSSBus offers free trials so that you can fully evaluate...

The choice between direct connectivity and replication just depends on your business requirements. The linked server approach directly proxies queries to Salesforce data (ODBC) for reporting etc. This...

Jason, I'm not sure that I follow - the article is not in any way attempting to be misleading, nor does the fact that it is an article imply that...

Yes - you can use the RSSBus ADO.NET provider for QuickBooks as a standard ADO.NET Data Source with full CRUD support. If you use the Visual Studio designers there...

It's a standard ADO.NET Data Source so you should be fine with 2005 or later

Take a look at the Salesforce ADO.NET Data Provider - http://www.rssbus.com/ado/salesforce/ . There is a sample article at http://www.rssbus.com/kb/articles/ado-ssistask.rst that demonstrates using the ADO.NET providers...