SSIS Salesforce Integration Pack
SSIS Salesforce Integration Pack is your complete toolset to automate Salesforce integration scenarios in SSIS. Using simple drag and drop interface you can read data from Salesforce or Bulk insert/update data into Salesforce. You can also execute any valid Salesforce API calls inside SSIS. It includes Salesforce Source Connector, Salesforce Destination Connector, Salesforce Connection Manager and Salesforce API Task.
SSIS Salesforce Source Connector (Query/Read/Extract CRM Data)
|SSIS Salesforce Source Connector can be used to extract large amount of data from Salesforce.com without any programming. You can use simple Table mode or Query mode with full SOQL query language support (SOQL=Salesforce.com Object Query Language).
SSIS Salesforce Destination Connector (Bulk Insert, Update, Delete, Upsert)
|SSIS Salesforce Destination can be used to bulk insert/delete large amount of records to Salesforce storage from any data source using SSIS.
SSIS Salesforce API Task (Call REST/SOAP API)
|SSIS Salesforce API Task can be used to call any Salesforce.com API (e.g. REST/SOAP) which can be in XML or JSON format. This task provides easy way to save response into file or variable.
SSIS Salesforce Connection Manager
|SSIS Salesforce Connection Manager can be used with Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source to read/write Salesforce.com data or execute various actions via API calls.