The SSIS Integration Toolkit for Salesforce components to facilitate integration with Salesforce applications.

The Salesforce SSIS toolkit includes a connection manager, a Source and a Destination components to connect to Salesforce.com Instance.

These components can be used with any other SSIS component to create your integration or migration project.

Youtube Video - Getting started with the SSIS Integration Toolkit for Salesforce

For additional resources on Salesforce migration and integration projects, we recommend the book, Developing Data Migrations and Integrations with Salesforce.

Installation and Setup

Salesforce
  • Salesforce Connection Manager
    • Salesforce connection manager allows you to specify how you want to connect to Salesforce.com.
  • Salesforce Source Component
    • Salesforce Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from your Salesforce.com instance. Salesforce source component supports using either a Salesforce object, or an object query statement as the data source.
  • Salesforce Destination Component
    • Salesforce Destination Component is an SSIS data flow pipeline component that can be used to write data to your Salesforce.com instance. You may Create, Update, Delete, Upsert, Merge, or HardDelete Salesforce records using the Salesforce Destination Component.