Included in SSIS PowerPack

SSIS Salesforce Destination

Bulk insert, update, upsert and delete Salesforce records from any SSIS source, without programming.

Map columns with drag and drop and run Insert, Update, Upsert or Delete against any Salesforce object. Switch on Bulk API mode for millions of rows or multiple threads for faster loads, capture inserted and updated rows in separate outputs, fire assignment rules for Case, Lead or Account, and connect with OAuth for MFA-protected orgs.

The trial includes Salesforce Destination and every other PowerPack component

SSIS Salesforce connection manager (shared by Salesforce Source, Destination, API Task, JSON Source and XML Source)
Salesforce connection manager: connect once, then load with Salesforce Destination

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Salesforce Destination can do

Salesforce Destination loads data from any SSIS source into Salesforce objects with bulk Insert, Update, Upsert (by Id, External ID or IdLookup field) and Delete, using the standard API or the Bulk API.

Load data into Salesforce

Load data into Salesforce.com from any source with a drag and drop interface, without programming.

  • Simple drag and drop column mapping
  • BatchSize: rows sent in each request

Load data in Salesforce guide

Insert, update, upsert & delete

Perform multiple write operations, including Bulk Insert, Update, Upsert and Delete.

  • Operation: Insert, Update, UpdateOrInsert or Delete
  • UpsertKeyField: Id, External ID or IdLookup field

Load data in Salesforce guide

Bulk API mode

Use the Salesforce BULK API to load millions of rows.

  • EnableBulkApiMode and BulkApiVersion (V1 or V2)
  • MaxRowsPerJob to avoid memory errors
  • ConcurrencyMode: Parallel or Serial (helps with row locks)

Component properties

Multi-threaded loading

Enable multiple threads for faster data loading.

  • EnableParallelProcessing
  • MaxParallelThreads: 1 to 40

Component properties

Upsert outputs & errors

Capture inserted and updated rows when you upsert, and redirect failed rows.

  • Outputs for new, updated and failed records
  • Progress every N rows and a row count summary at the end

Error handling

Assignment rules

Run an assignment rule after insert or update for Case, Lead or Account.

  • AssignmentRuleId for a specific rule
  • UseDefaultAssignmentRule for the default rule

Component properties

Null & save options

Control how NULLs, long values and duplicates are written.

  • IgnoreFieldsIfInputNull / FieldsToSetNullIfInputNull
  • AllOrNone, AllowFieldTruncation, AllowSaveOnDuplicates on the connection

Component properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

Secure Salesforce connection

Highly secure data transfer using TLS 1.2 encryption.

  • OAuth Access Token support (helpful for 2FA / MFA)
  • Production, Sandbox or Developer orgs
  • Error retry and proxy settings

Connection Manager help

See all features
  • Load data into Salesforce.com from any source with drag and drop user interface
  • Multiple write operations (Bulk Insert, Update, Delete, Upsert)
  • Upsert by Id, External ID or IdLookup field
  • BULK API mode (millions of rows can be loaded with this mode), V1 or V2
  • Multiple threads for faster data loading
  • Highly secure data transfer using TLS 1.2 encryption
  • Capture outputs for updated or inserted rows in Upsert operation
  • OAuth Access Token support (helpful for 2FA / MFA)
  • Execute assignment rule after Update / Insert for Case, Lead or Account
  • Report progress every N rows and a row count summary at the end
  • Option to ignore NULL input values or set selected fields to NULL
  • Error output for failed records
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Connect, choose the operation and key, map columns, then route new, updated and failed rows.

Connect to Salesforce.

Add a ZS-SALESFORCE connection and choose OAuth 2.0 (interactive, useful with MFA / 2FA) or OAuth 2.0 Client Credentials; the user name, password and security token method is legacy. Pick Production, Sandbox or Developer and click Test Connection.

  • Shared with Salesforce Source and Salesforce API Task
  • TLS 1.2 encrypted transfer
  • Retry and proxy settings

Connection manager help

SSIS Salesforce connection manager

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Salesforce Destination product page. Step through them, or open any shot at full size.

Salesforce Connection Manager

One connection manager shared by Salesforce Source, Salesforce Destination, Salesforce API Task, JSON Source and XML Source.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Salesforce Destination on the canvas.

What is Salesforce Destination?

Salesforce Destination is an SSIS data flow destination that loads data from any source into Salesforce objects with bulk Insert, Update, Upsert and Delete operations, using simple drag and drop mapping.

Which key can I use for upsert?

Set UpsertKeyField to the Id field, an External ID field or an IdLookup field. An External ID lets you upsert without storing Salesforce Ids in your source; the load tutorial shows how to create one.

When should I use Bulk API mode?

For large volumes. Set EnableBulkApiMode and pick BulkApiVersion V1 or V2 (V2 helps with locking issues). Lower MaxRowsPerJob if you hit memory errors, and use Serial ConcurrencyMode if you get row-lock errors. For smaller loads the standard mode may be faster.

Can I see which rows were inserted, updated or failed?

Yes. In upsert mode, new and updated records go to the output and failed records to the error output. Progress is reported every N rows, with a summary of total, inserted, updated, deleted and error counts at the end.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Salesforce Destination onto the Data Flow.

Bulk insert, update, upsert and delete Salesforce records from SQL Server, files or any SSIS source.

  • Data Flow Destination in SSISSalesforce Destination appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 8