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

The Salesforce SSIS toolkit includes a connection manager, a Source and a Destination component to connect to a Salesforce 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
    • The Salesforce Connection Manager allows you to specify how you want to connect to Salesforce.
  • Salesforce Source Component
    • The Salesforce Source Component is an SSIS data flow pipeline component that can be used to read/retrieve data from your Salesforce Instance. The Salesforce Source Component supports using either a Salesforce object, or an object query statement as the data source.
  • Salesforce Destination Component
    • The Salesforce Destination Component is an SSIS data flow pipeline component that can be used to write data to your Salesforce Instance. You may Create, Update, Delete, Upsert, Merge, or HardDelete Salesforce records using the Salesforce Destination Component.