SSIS Data Flow Components for Salesforce: SQL Queries, Bulk API Loads and Lookups for Salesforce in SSIS
SSIS Data Flow Components for Salesforce is Devart's Salesforce connector for SQL Server Integration Services: a Source, Destination, Lookup and Connection Manager that read and write accounts, contacts, opportunities, leads, users, attachments, tasks and custom objects, with the Bulk API for large jobs. It's for data engineers who move Salesforce data to and from SQL Server or other systems in SSIS packages, runs on Windows, and costs $199.95 a year for one developer, or $399.95 for a perpetual license.
Salesforce sits at the centre of many companies' customer data, and SSIS has no Salesforce source or destination of its own. These components fill that gap, with SQL in place of SOQL, server-to-server sign-in for unattended jobs, and the load controls (batch size, parallel batches, Bulk API, External ID fields) that big Salesforce loads need.
Quick facts
- Version: 5.1.49, released August 17, 2026
- Developer: Devart
- Components: Salesforce Source, Destination, Lookup and Connection Manager
- Sign-in: username, password and security token; OAuth 2.0; interactive OAuth; server-to-server (client credentials); session ID
- Salesforce API: Web Services API version 64.0 supported since version 5.0.0; Bulk API for reads and writes
- SSIS versions: SQL Server Integration Services 2012, 2014, 2016, 2017, 2019, 2022 and 2025
- Platform: Windows Vista and later, 32-bit and 64-bit, with .NET Framework 4.5
- Price: $199.95 a year for one developer (subscription), $399.95 perpetual. Server and Site licenses available
- Trial: 30 days, fully functional; the 618.60 MB download needs a free Devart account
- Refunds: Devart's ordering FAQ allows a full refund within 30 days of purchase only when a technical problem or bug stops the product working and support can't fix it
- What we checked: the Salesforce component dialogs, sign-in options and the 5.1.49 release on Devart's pages, and the order page on November 16, 2026: SSIS Data Flow Components for Salesforce at $199.95 for the default one-year Developer subscription (renewing yearly), $399.95 Developer perpetual, $499.95 and $999.95 for Server subscription and perpetual, and $999.95 for a perpetual Site license. We didn't install the components or connect them to a Salesforce org.
Download Free TrialBuy Now
Overview
After installation, Devart Salesforce Source, Destination and Lookup appear in Visual Studio's SSIS Toolbox. You add a Devart Salesforce Connection Manager for login.salesforce.com (or a sandbox or Database.com login URL), sign in, and write a SELECT in the Source editor against any object. The Destination inserts, updates or deletes records, and the Lookup matches incoming rows against Salesforce data.
This is one of Devart's longest-running SSIS connectors, and it keeps up with Salesforce's API: version 2.0.16 (September 2021) supported Web Services API 52.0, 2.1.411 (July 2023) API 55.0, 3.0.630 (September 2024) API 59.0, and 5.0.0 (June 2026) API 64.0, together with server-to-server authentication and a Preserve Names option that keeps the __c suffix on custom objects and fields. Version 5.1.49 (August 2026) fixed loading into the ContentVersion table.
The Devart Salesforce Source Editor: Account fields on the left, a SELECT of Account Name, Phone, Website, BillingState, Type and LastModifiedDate, the Include Deleted Records box at the top right, and the Preview Data window.
Features
SQL instead of SOQL, with deleted records if you want them
SSIS Data Flow Components for Salesforce's Source takes a SQL SELECT with grouping, filtering and ordering. Simple statements are translated into Salesforce API calls; more complex ones are finished locally after the data is fetched. An Include Deleted Records box adds rows from the recycle bin, a BulkQuery property switches large reads to the Bulk API, and an OptimizeQuery property speeds up big retrievals.
Every Salesforce sign-in method
SSIS Data Flow Components for Salesforce's connection manager supports username, password and security token; OAuth 2.0 with a web sign-in that fills in the refresh token; interactive OAuth that also fills in the client ID and secret; server-to-server (OAuth client credentials with an external client app's consumer key and secret) for unattended jobs, added in 5.0.0; and session ID. Header options control whether Salesforce sends auto-response, user and other emails and updates the most-recently-used list when records change, and a proxy can be set.
The Devart Salesforce Connection Manager Editor with login.salesforce.com, UserNamePassword and a security token, plus the advanced editor's Header Options (batch size, Trigger AutoResponse Email, Trigger User Email, Update MRU, Use Assignment Rules) and initialization settings.
Bulk API and parallel batches for big loads
SSIS Data Flow Components for Salesforce's Destination inserts, updates and deletes records with either the SOAP API or the Bulk API (UseBulkApi), with batch size, buffer size and parallel or serial batch processing set per component. It has an ExternalId property for Salesforce External ID fields, and new leads or cases can go through a specific assignment rule (Assignment Rule Id) or the default one.
Advanced Editor for the Devart Salesforce Destination: Action Insert, BatchSize 5000, BufferSize, ExternalId, ParallelBatchProcessing and UseBulkApi set to True.
A lookup that respects API limits
SSIS Data Flow Components for Salesforce's Lookup checks several rows per request and caches results, so matching thousands of rows doesn't use thousands of API calls. Batch and cache sizes, case-insensitive matching and what to do with no match or several matches are set in its properties.
Advanced Editor for the Devart Salesforce Lookup on the Account object: BatchSize 50, CacheSize 2000, CaseInsensitiveLookup, LocalSQLEngine, NoMatchAsError and UseFirstMatchInMultipleResults.
Benefits
- Salesforce in the ETL you already run. No separate integration service: SSIS packages, the SSIS catalog and SQL Server Agent handle Salesforce like any other source.
- Fewer API calls on big jobs. Bulk API reads and writes, parallel batches and a caching lookup keep large loads inside your org's API limits.
- Unattended jobs without a user password. Server-to-server sign-in fits scheduled packages and survives password resets.
- SQL skills carry over. Developers query Salesforce with the SELECT statements they already write, without learning SOQL.
Real-World Uses
- Salesforce backup. A nightly package copies accounts, contacts, opportunities and attachments, deleted records included, into SQL Server tables.
- Reporting warehouse. Opportunities and activities land in SQL Server or another warehouse for Power BI, joined with finance data Salesforce doesn't have.
- ERP to CRM sync. Customer and product data from an ERP database are inserted or updated in Salesforce on a schedule.
- Lead routing from other systems. Leads collected in a SQL Server database are inserted into Salesforce through the org's assignment rules.
Who It's For, and Who Should Skip It
It's for SQL Server shops that run SSIS and need Salesforce data in or out on a schedule, especially with large volumes where the Bulk API and parallel batches matter, or where unattended jobs need server-to-server sign-in.
Skip it if you don't use SSIS: these are SSIS components, not a standalone backup or sync service. If you work with Salesforce Marketing Cloud, that's a separate Devart connector. And if Salesforce is one of several systems you integrate, the SSIS Universal Bundle covers every Devart source for $499.95 a year.
Usage Guide
- Install. Sign in with a free Devart account on the download page, close Visual Studio, and run the installer (the same 618.60 MB package Devart uses for all its SSIS components) on the development machine and the SSIS server.
- Create the connection. In an Integration Services project, add a Devart Salesforce connection manager and choose the host and sign-in type. For scheduled jobs, pick ClientCredentials (server-to-server) and enter your external client app's consumer key and secret; for quick tests, OAuth with Sign In is easiest.
- Query. Drop the Devart Salesforce Source into a data flow, drag fields from an object into the query box, tick Include Deleted Records if needed, and preview the rows.
- Load. Send rows to the Devart Salesforce Destination, choose Insert, Update or Delete, set the External ID, batch size and UseBulkApi, and map the columns.
- Deploy. Deploy the package to the SSIS catalog and schedule it with SQL Server Agent.
Before you buy
The default order is a one-year Developer subscription at $199.95, which renews yearly; the subscription license works only while it's active and needs an Internet connection to activate and check the license. The perpetual Developer license ($399.95) keeps working at your version and activates offline. A Developer license covers building and testing packages on one developer's workstations; deploying packages to a production server needs a Server license ($499.95 a year or $999.95 perpetual), which also covers one developer. A Site license covers unlimited computers in one company.
Where it falls short
- Salesforce-specific fixes keep coming. Recent releases fixed AccessRefreshToken sign-in (3.2.1007), number-format error redirection in the Destination (3.0.630) and ContentVersion loading (5.1.49), so stay on current updates.
- Complex queries pull data locally. SELECTs the API can't run are processed after the data is fetched, which can be slow and costly in API calls on large objects.
- Assignment rules cost a round-trip. Turning on Use Assignment Rules adds an extra call to Salesforce at each connection; setting an Assignment Rule Id on the Destination avoids it.
- Big download for one connector. The installer is 618.60 MB because it's the same package as the full bundle.
What Users Say
Review sites rate Devart's SSIS components as one product line rather than the Salesforce connector alone, and the review counts are small.
Capterra and SoftwareReview
SSIS Data Flow Components averages 4.6 out of 5 from 12 reviews on Capterra, with 4.3 for ease of use and 4.3 for customer service. SoftwareReview shows 4.7 out of 5 from 9 ratings. Reviewers call the components intuitive, and the main complaint is documentation that doesn't cover every part of the data flow components.
G2
On G2, Devart's Universal SSIS Components page has about 20 reviews averaging 4.5. Reviewers praise ease of use, handling of large data volumes and integration with SQL Server and Azure. The criticism is occasional crashes when opening packages and support replies that are slower than they'd like.
In short: good marks for ease of use and throughput, with complaints about documentation and occasional stability problems. With a few dozen ratings across all sites, run the trial against your own Salesforce account before deciding.
Comparisons
SSIS Data Flow Components for Salesforce vs SSIS Universal Bundle
Devart's SSIS Universal Bundle includes this Salesforce connector plus components for Salesforce Marketing Cloud, Dynamics 365, HubSpot, NetSuite, SQL Server, Snowflake and the rest of Devart's 50-plus sources. It costs $499.95 a year or $999.95 perpetual for one developer, against $199.95 and $399.95 for Salesforce alone. If you'll need three or more Devart connectors, the bundle costs less than buying them one by one.
SSIS Data Flow Components for Salesforce vs SSIS Data Flow Components for Salesforce Marketing Cloud
Salesforce CRM and Marketing Cloud are separate platforms with separate APIs, and Devart sells a separate SSIS connector for each, at the same price. The Salesforce components reach CRM objects such as accounts, contacts, opportunities and custom objects, with the Bulk API; the Marketing Cloud components reach subscribers, emails and data extensions. Syncing the two in SSIS needs both, or the bundle.
Editions and Pricing
The Buy Now button opens the order page with the Developer subscription selected; you choose the license type, subscription or perpetual, term and premium support there. Prices on November 16, 2026:
| License | Subscription (1 year) | Perpetual | What it covers |
| Developer | $199.95 | $399.95 | One developer's workstations, for development and testing |
| Server | $499.95 | $999.95 | One server running packages, plus one developer |
| Site for 10-100 Devices | On the order page | $999.95 | Unlimited computers in one company |
Two- and three-year terms and premium support are options on the order page.
FAQs
Can SSIS Data Flow Components for Salesforce connect to a Salesforce sandbox?
Yes. SSIS Data Flow Components for Salesforce's connection manager takes the login URL as its Host, so you can point it at your sandbox's login URL instead of login.salesforce.com, as well as at Database.com.
Does SSIS Data Flow Components for Salesforce keep the __c suffix on custom fields?
It can. SSIS Data Flow Components for Salesforce added a Preserve Names connection option in version 5.0.0 that keeps the original Salesforce names of custom objects and fields, __c suffix included.
Can SSIS Data Flow Components for Salesforce run without a user's password?
Yes. SSIS Data Flow Components for Salesforce supports server-to-server authentication (OAuth client credentials) since version 5.0.0, using the consumer key and secret of an external client app, with no user sign-in or security token.
Does SSIS Data Flow Components for Salesforce work with SSIS 2008?
No. SSIS Data Flow Components for Salesforce need SQL Server Integration Services 2012 or later, up to SSIS 2025; only Devart's database components still support SSIS 2008.
What happens when the subscription ends?
The subscription license of SSIS Data Flow Components for Salesforce only works for the term you paid for, so packages that use it need a renewal. A perpetual license keeps working at the version you have without a subscription.
Do I need a separate license for the production SSIS server?
Yes. The Developer license of SSIS Data Flow Components for Salesforce covers development and testing only. Deploying packages to a server needs a Server license ($499.95 a year or $999.95 perpetual) or a Site license.
Can I get a refund for SSIS Data Flow Components for Salesforce?
Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops the product working and support can't fix it, so contact support first. Use the 30-day trial to test with your own data before buying.
System Requirements
- Microsoft SQL Server Integration Services 2012, 2014, 2016, 2017, 2019, 2022 or 2025
- Visual Studio with SQL Server Data Tools / Integration Services projects for designing packages
- Windows Vista or later, 32-bit or 64-bit, with .NET Framework 4.5
- A Salesforce org whose edition and user have API access
Conclusion
SSIS Data Flow Components for Salesforce is worth $199.95 a year (or $399.95 once) for an SSIS team that moves Salesforce data in volume. The one reason to buy it is the load side: Bulk API, parallel batches, External ID support and assignment rules, plus server-to-server sign-in for unattended jobs, all inside SSIS. The main reasons to hold back are the separate Server license for production and the need to keep updating as Salesforce's API moves; and if Salesforce is one of several cloud systems you connect, the $499.95 Universal Bundle is the better buy. Try it on your own org in the 30-day trial.
Download Free TrialBuy Now