Included in SSIS PowerPack

SSIS Salesforce Source

Extract Salesforce objects and SOQL query results into your SSIS data flow.

Read a Salesforce object in Table mode or write a SOQL query, make it dynamic with SSIS variables, convert UTC and local date/time, and send rows to SQL Server or another SSIS destination, all without any programming.

The trial includes Salesforce Source and every other PowerPack component

SSIS Salesforce Source in Query mode with a SOQL query, variables, and data preview
Table mode, SOQL queries & SQL Server

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 Source can do

Salesforce Source extracts large amounts of data from Salesforce.com without any programming. Use simple Table mode or Query mode with full SOQL support, then load SQL Server like any other SSIS source.

Table or Query mode

Multiple modes to read data from Salesforce CRM.

  • Table mode: pick a Salesforce object from the list
  • Query mode: full SOQL (Salesforce Object Query Language) support
  • Object Browser with fields and table info

See the access modes

SOQL queries

Write SOQL with WHERE, ORDER BY, LIMIT, relationships, and aggregates.

  • Parent fields with the dot operator (e.g. Account.Name)
  • Child records with a nested SELECT
  • GROUP BY with optional HAVING

See the SOQL example

Dynamic queries

Make a query dynamic with SSIS variables.

  • Variable placeholders such as {{User::MyVar}}
  • Insert Variable button in the query editor
  • Date literals such as TODAY, YESTERDAY, LAST_N_DAYS:365

See the SOQL example

UTC & local date/time

Automatic conversion between UTC date/time and local date/time.

  • Output dates as local time, UTC, or ISO format
  • DateTime variables convert to UTC in queries

See date/time options

Preview, max rows & batch size

Check the data before you map a destination.

  • Data preview in the UI
  • Maximum rows to fetch (0 = unlimited)
  • Rows fetched in each request (batch size)

See the screenshots

Salesforce connection

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

  • User name, password, and security token
  • Service type (e.g. Production) and service URL
  • OAuth access token (helpful for 2FA / MFA)

See the connection

Large data & deleted records

Options for large or special reads.

  • Bulk API mode for large amounts of data
  • Read deleted records (IncludeDeleted)

Bulk API guide

Error handling

Choose what happens when a row fails.

  • Fail the component, ignore the failure, or redirect the row to the error output
  • Separate settings for errors and truncation

See error handling

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

See all features
  • Multiple modes to read data from Salesforce CRM (i.e. Table or Query)
  • Support for SOQL (Salesforce Object Query Language)
  • Automatic conversion between UTC date/time and local date/time
  • Intuitive user interface with Salesforce Object Browser
  • Data preview, max rows, and batch size
  • OAuth access token (helpful for 2FA / MFA)
  • Dynamic query using an SSIS variable placeholder (e.g. {{User::MyVar}})
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

  • Read from a Salesforce custom report: use this technique
  • Read metadata (tables / fields): use this technique
Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

Two access modes

Read a whole object or exactly the rows your query asks for.

Create a Salesforce connection once, then pick Table or Query mode. Preview rows in the UI before you map columns.

Get data from a Salesforce object.

Select the connection, set Access Mode to Table, and choose an object such as Account from the list. Click Preview to see the rows.

  • No query to write
  • Max rows and batch size options
  • Object Browser shows fields and table info
SSIS Salesforce Source in Table mode with the Account object and data preview

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Salesforce Source help file and product page. Step through the connection, both modes, variables, and errors, or open any shot at full size.

Table mode

Pick a Salesforce object such as Account and preview the rows.

SOQL example

A dynamic SOQL query, start to finish.

From the Salesforce Source help file: three SSIS variables feed a SOQL query, and the preview returns the matching account.

  1. SOQL query

    Variables: Name = %n%, BillingCountry = USA, NumberOfEmployees = 1500.

    Query

    SELECT Id, Name, BillingCountry, NumberOfEmployees
    FROM Account
    WHERE Name LIKE '{{User::Name}}'
    and BillingCountry = '{{User::BillingCountry}}'
    and NumberOfEmployees >= {{User::NumberOfEmployees}}
  2. Set the access mode

    Access ModeQuery

    Select the Salesforce connection, then use Insert Variable to add the placeholders.

  3. Output rows for your data flow

    Data preview from the help file
    Id Name BillingCountry NumberOfEmployees
    0010K000021vb8DQAQ Burlington Textiles Corp of America USA 9000

    Connect these rows to SQL Server or another SSIS destination.

More SOQL examples from the help file

Query What it shows
SELECT Id,FirstName, LastName, Account.Name FROM Contact Parent fields (child-to-parent)
SELECT Name, (SELECT FirstName, LastName FROM Contacts ORDER BY CreatedDate LIMIT 5) FROM Account Where Name='ZappySys' Child records, top 5 per account
SELECT LeadSource, COUNT(Name) Cnt FROM Lead GROUP BY LeadSource HAVING COUNT(Name) > 100 GROUP BY / aggregate
... Where LastModifiedDate < {{System::ContainerStartTime,TO_UTC_DATETIME}} AND CreatedDate < YESTERDAY Date variable converted to UTC, plus a date literal
SELECT Id FROM Account WHERE Name = 'Sam\'s Farm' Escape a special character

Query, variables, and preview from the Salesforce Source help file, which lists more SOQL examples.

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 Source on the canvas.

What can Salesforce Source read?

Any Salesforce object in Table mode, or the result of a SOQL query in Query mode. For custom reports or metadata, ZappySys documents separate techniques (see Features).

How do I make a query dynamic?

Use variable placeholders such as {{User::MyVar}} anywhere in the SOQL query; the Insert Variable button adds them for you. DateTime variables are converted to UTC by default.

Does SOQL support JOINs?

No. SOQL is similar to SQL but simpler, and the JOIN clause is not supported. Use parent fields (e.g. Account.Name) or a nested child query instead.

How are dates handled?

Output dates can be converted to local time, UTC, or ISO format, and input date values in Query mode can be converted the same way.

Can it read a large amount of data?

Yes. It is built to extract large amounts of data, and a Bulk API mode is available for large reads. For very large sets see the Bulk API guide.

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.

Where is the full property reference?

Open the Salesforce Source help file for properties and SOQL examples. System requirements are on the installation page.

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 Source onto a Data Flow.

Preview real Salesforce data before you map a destination, with no programming required.

  • Data Flow Source in SSISSalesforce Source 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 / 9