ADO.NET provider for Salesforce from Devart offers the easiest way for integrating Salesforce services into .NET applications and now includes the following components:
Devart Salesforce Source component*allows querying data with both SOQL and SQL. It provides advanced visual editor with object tree, that displays all the Salesforce objects with their properties and allows users to just drag Salesforce to the query editor to create a query. The source component is able to query data with or without deleted records or system fields.
Devart Salesforce Destination component*uses native bulk protocol for loading data. It supports all kinds of load operations - insert, update, delete, and upsert, and offers an advanced per-row error processing, creating an error output with Salesforce IDs of the records, loaded successfully, and error information columns for records that caused the error. It can insert related objects without modifying database, no need to create external id fields for parent objects.
Read more about dotConnect for Salesforce SSIS components.