SSIS Data Flow Components for Salesforce Marketing Cloud
SSIS Data Flow Components for Salesforce Marketing Cloud icon

SSIS Data Flow Components for Salesforce Marketing Cloud

by Devart
$199.95
Version
5.1.49
License
Shareware
Trial Limitations
Fully functional 30-day trial. The download needs a free Devart account
Operating Systems
Windows Vista and later, 32-bit and 64-bit
System Requirements
SQL Server Integration Services 2012 to 2025, Visual Studio with SSIS projects, .NET Framework 4.5, a Salesforce Marketing Cloud account with API access
File Size
618.60 MB
Release Date
8/17/2026
Last Updated
11/16/2026
15 views 0 downloads
Devart SSIS Source, Destination and Lookup for Salesforce Marketing Cloud

SSIS Data Flow Components for Salesforce Marketing Cloud: Subscribers, Emails and Data Extensions in SSIS

SSIS Data Flow Components for Salesforce Marketing Cloud (formerly the ExactTarget components) is Devart's Marketing Cloud connector for SQL Server Integration Services: a Source, Destination, Lookup and Connection Manager that read and write subscribers, emails, data extensions and other Marketing Cloud objects with SQL. It's for BI developers and marketing-ops engineers who sync Marketing Cloud with SQL Server or a CRM in SSIS packages, runs on Windows, and costs $199.95 a year for one developer, or $399.95 for a perpetual license.

Marketing Cloud data usually leaves the platform as scheduled CSV exports, which someone then imports by hand or with a script. With these components, an SSIS package queries Marketing Cloud directly, writes the results to SQL Server, and can push updated subscriber or data extension rows back in the same job.

Quick facts

  • Version: 5.1.49, released August 17, 2026
  • Developer: Devart
  • Components: Salesforce Marketing Cloud Source, Destination, Lookup and Connection Manager
  • Objects: subscribers, emails, accounts, data extensions and other Marketing Cloud objects, including SubscriberStatusEvent
  • Sign-in: Server-to-Server (enhanced package client ID and secret), username and password, refresh token, or legacy App Center client
  • 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 Marketing Cloud component dialogs, authentication 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 Marketing Cloud 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 Marketing Cloud account.

Download Free TrialBuy Now

Overview

Install the components and four Devart Salesforce Marketing Cloud items appear in Visual Studio's SSIS Toolbox. You set up a Devart Salesforce Marketing Cloud Connection Manager with your account's subdomain and an installed package's client ID and secret, drop the Source into a data flow, and write a SELECT against an object such as Account, Subscriber or a data extension. The Destination inserts, updates or deletes Marketing Cloud records, and the Lookup matches incoming rows against Marketing Cloud data.

The connector has been around since Marketing Cloud was called ExactTarget; Devart renamed it in version 2.1.411 (July 2023). Its change log added OAuth 2 in 2019, Server-to-Server authentication in version 1.11.1056 (October 2019) and the SubscriberStatusEvent table in 1.12.1140 (February 2020). Later releases, up to 5.1.49 in August 2026, bring the shared fixes for cloud data sources and support for new SSIS and Visual Studio versions.

SSIS Data Flow Components for Salesforce Marketing Cloud Source Editor with Account fields, a SELECT query and Preview Data

The Devart Salesforce Marketing Cloud Source Editor: Account fields in the object tree, a SELECT of Name, Email, Phone, Address and Fax, package variables on the right, and the Preview Data window with the returned row.

Features

SQL queries against Marketing Cloud

SSIS Data Flow Components for Marketing Cloud's Source takes a SQL SELECT for any Marketing Cloud object. Simple statements are translated into Marketing Cloud API calls and run on Marketing Cloud's side; more complex ones, with grouping, filtering and ordering, fetch the needed data and finish the query locally. A connection setting turns the local SQL engine off, so that only statements the API can run directly are allowed.

Data extensions, not just standard objects

SSIS Data Flow Components for Marketing Cloud work with data extensions as well as subscribers, emails, accounts and the other standard objects, so the custom tables your journeys and sends depend on can be loaded from or exported to SQL Server.

Server-to-Server and other sign-in types

SSIS Data Flow Components for Marketing Cloud's connection manager supports Server-to-Server authentication with the 28-character "mc..." subdomain and the client ID and secret of an enhanced installed package, plus username and password (API user), refresh token, and the old App Center client method, which only works with legacy packages created before August 1, 2019. Advanced options restrict retrieve requests to specific business units with Client IDs, route through a proxy, open the connection read-only, and set failover retries for temporary errors.

Write back with INSERT, UPDATE and DELETE

SSIS Data Flow Components for Marketing Cloud's Destination loads data into Marketing Cloud with all three DML operations, with the action and batch size set in the component's properties. That covers pushing new subscribers from a CRM, updating attributes calculated in the warehouse, or removing rows from a data extension.

A lookup that batches and caches

SSIS Data Flow Components for Marketing Cloud's Lookup checks several incoming rows at once and caches the results, which cuts the number of round-trips to the Marketing Cloud API when a package matches thousands of rows.

Benefits

  • No more manual export files. Packages query Marketing Cloud directly instead of waiting for scheduled CSV extracts.
  • Two-way sync in one job. Read engagement data out and push updated subscriber attributes back in the same SSIS package.
  • SQL you already know. SELECT with filters and grouping works even where the Marketing Cloud API has no such query.
  • Runs on your servers. Data goes straight between Marketing Cloud and your SSIS server, under your own scheduling and logging.

Real-World Uses

  • Subscriber sync. A nightly package loads new and changed contacts from SQL Server or a CRM into a Marketing Cloud data extension.
  • Engagement reporting. Subscriber status events and email data land in SQL Server, where they join sales data for Power BI dashboards.
  • Unsubscribe handling. Subscriber status changes flow back into the company database so other systems stop mailing people who opted out.
  • Data extension refresh. Product, pricing or loyalty tables used for personalization are refreshed from the warehouse before each send.

Who It's For, and Who Should Skip It

It's for teams that run SQL Server Integration Services and need Marketing Cloud data in or out on a schedule, especially when data extensions feed sends and need regular refreshes from internal systems.

Skip it if you don't use SSIS: these are SSIS components, not a standalone sync tool. If you also need Salesforce CRM, Dynamics 365 or other sources, the SSIS Universal Bundle covers them all for $499.95 a year. And if Marketing Cloud's own import activities already cover your file loads, you may not need a separate connector.

Usage Guide

  1. Prepare Marketing Cloud. Create an installed package with a Server-to-Server API integration, give it the permissions your package needs, and note the client ID, client secret and your subdomain.
  2. 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.
  3. Create the connection. In an Integration Services project, add a Devart Salesforce Marketing Cloud connection manager, choose ServerToServer, enter the subdomain, client ID and secret, and test it.
  4. Query. Drop the Devart Salesforce Marketing Cloud Source into a data flow, pick an object or data extension, write the SELECT and preview the rows.
  5. Load back. Use the Destination with the Insert, Update or Delete action to write to Marketing Cloud, or the Lookup to match rows. Deploy and schedule the package as usual.

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

  • Few Marketing Cloud-specific updates lately. The change log's last entries naming this connector are from 2019 and 2020 (Server-to-Server sign-in, SubscriberStatusEvent) and the 2023 rename; newer releases only list shared cloud fixes. Check in the trial that the objects you need are there.
  • Complex queries pull data locally. SELECTs the API can't run are processed after the data is fetched, which can be slow on large data extensions.
  • Legacy sign-in is a dead end. App Center client authentication only works with packages created before August 1, 2019; new setups need Server-to-Server.
  • 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 Marketing Cloud 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 Marketing Cloud account before deciding.

Comparisons

SSIS Data Flow Components for Salesforce Marketing Cloud vs SSIS Universal Bundle

Devart's SSIS Universal Bundle includes this Marketing Cloud connector plus components for Salesforce CRM, Mailchimp, Marketo, HubSpot, 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 Marketing Cloud 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 Marketing Cloud vs SSIS Data Flow Components for Salesforce

Marketing Cloud and Salesforce CRM are separate platforms with separate APIs, and Devart sells a separate SSIS connector for each, at the same price. The Marketing Cloud components reach subscribers, emails and data extensions; the Salesforce components reach CRM objects such as accounts, contacts and opportunities. 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:

LicenseSubscription (1 year)PerpetualWhat it covers
Developer$199.95$399.95One developer's workstations, for development and testing
Server$499.95$999.95One server running packages, plus one developer
Site for 10-100 DevicesOn the order page$999.95Unlimited computers in one company

Two- and three-year terms and premium support are options on the order page.

FAQs

Is SSIS Data Flow Components for Salesforce Marketing Cloud the old ExactTarget connector?

Yes. SSIS Data Flow Components for Salesforce Marketing Cloud is the product Devart sold as SSIS Data Flow Components for ExactTarget; it was renamed in version 2.1.411, and some component names still say ExactTarget internally.

Which authentication should I use with SSIS Data Flow Components for Marketing Cloud?

Server-to-Server. SSIS Data Flow Components for Marketing Cloud's Server-to-Server type uses your subdomain plus the client ID and secret of an enhanced installed package, which is what Marketing Cloud issues for new integrations. App Center client sign-in only works with legacy packages created before August 1, 2019.

Can SSIS Data Flow Components for Marketing Cloud read only one business unit?

Yes. SSIS Data Flow Components for Marketing Cloud's Client IDs connection option limits retrieve requests to specific partner accounts or business units.

Does SSIS Data Flow Components for Marketing Cloud work with SSIS 2008?

No. SSIS Data Flow Components for Marketing Cloud 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 Marketing Cloud 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 Marketing Cloud 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 Marketing Cloud?

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 Marketing Cloud account with API access (an installed package for Server-to-Server sign-in)

Conclusion

SSIS Data Flow Components for Salesforce Marketing Cloud is worth $199.95 a year (or $399.95 once) for an SSIS team that has to move subscriber and data extension data between Marketing Cloud and SQL Server on a schedule. The one reason to buy it is SQL access to Marketing Cloud, data extensions included, with writes back through INSERT, UPDATE and DELETE, all inside the SSIS packages you already run. The main reason to hold back is that the connector's own updates have been sparse since 2020, so test the objects you depend on in the 30-day trial; and if you also need Salesforce CRM or other sources, the $499.95 Universal Bundle is the better buy.

Download Free TrialBuy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.