SSIS Data Flow Components for Dynamics 365: Read and Write Dynamics 365 Records from SSIS with SQL
SSIS Data Flow Components for Dynamics 365 is Devart's Microsoft Dynamics 365 connector for SQL Server Integration Services: a Source, Destination, Lookup and Connection Manager that query and update contacts, accounts, opportunities, leads, products and the other Dynamics 365 tables with SQL. It's for BI and integration developers who move CRM data between Dynamics 365 and 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.
Dynamics 365 runs in Microsoft's cloud, while many reporting databases and line-of-business systems still sit on SQL Server. These components let the SSIS packages you already schedule pull Dynamics 365 tables into SQL Server and push changes back, with OAuth sign-in instead of stored passwords.
Quick facts
- Version: 5.1.49, released August 17, 2026
- Developer: Devart
- Components: Dynamics 365 Source, Destination, Lookup and Connection Manager
- Sign-in: OAuth 2.0 (Devart's Microsoft-signed app or your own Azure AD app), interactive OAuth, or username and password; proxy servers supported
- 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 Dynamics 365 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 Dynamics 365 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 Dynamics 365 environment.
Download Free TrialBuy Now
Overview
Once installed, Devart Dynamics 365 Source, Destination and Lookup appear in Visual Studio's SSIS Toolbox. You add a Devart Dynamics 365 Connection Manager pointing at your environment's URL (for example https://yourorg.crm4.dynamics.com), sign in, then write a SELECT in the Source editor against any table the account can see. The Destination inserts, updates or deletes records, and the Lookup matches incoming rows against Dynamics 365 data.
The product started as Devart's Dynamics CRM components and was renamed for Dynamics 365 in version 2.1.411 (July 2023), which also brought a new Microsoft-signed app for OAuth sign-in. Earlier, version 1.13.1221 (June 2020) added Dynamics OAuth and MultiSelect Option Set columns. The latest release, 5.1.49 (August 2026), fixed OAuth login for tenants that require administrator consent, a problem reading the Account table and a GUID conversion error, and improved error messages for unsupported data types.
The Devart Dynamics 365 Source Editor: the environment's tables on the left, SELECT * FROM product in the query box, and the Preview Data window with product IDs and created/modified dates.
Features
SQL against Dynamics 365 tables
SSIS Data Flow Components for Dynamics 365's Source takes a SQL SELECT for any Dynamics 365 table the account can see. Simple statements are translated into Dynamics 365 API calls and run on Microsoft's side; more complex ones are completed by a local SQL engine after the data is fetched. The editor lists every table and its fields next to your SSIS variables, builds queries by drag and drop, and previews the returned rows.
OAuth sign-in, with your own app if you prefer
SSIS Data Flow Components for Dynamics 365's connection manager signs in with OAuth 2.0 through a web login, using Devart's Microsoft-signed app or a Client ID and Secret from an app you register in your own Azure AD tenant. An interactive OAuth mode fills in the refresh token, client ID and secret after you sign in from the Test Connection button. Plain username and password sign-in is still there, and a proxy host, port and credentials can be set for locked-down networks.
The Devart Dynamics 365 Connection Manager Editor with UserNamePassword authentication and a crm4.dynamics.com server, plus the advanced editor's pooling, provider and proxy options.
Write back with INSERT, UPDATE and DELETE
SSIS Data Flow Components for Dynamics 365's Destination loads data into Dynamics 365 with all three DML operations. You choose the action and batch size in the component's properties and map input columns to the table's fields, so a package can create leads from a web form database, update account fields from ERP data, or delete obsolete records.
Advanced Editor for the Devart Dynamics 365 Destination: Action set to Insert and BatchSize 500.
A lookup with batching and its own matching rules
SSIS Data Flow Components for Dynamics 365's Lookup checks several rows per request and caches results, which keeps API calls down when you match thousands of rows. Its properties include batch and cache sizes, case-insensitive matching, whether a missing match is an error, and whether to take the first match when a value returns several records.
Advanced Editor for the Devart Dynamics 365 Lookup: BatchSize 100, CacheSize 2000, CaseInsensitiveLookup, LocalSQLEngine, NoMatchAsError and UseFirstMatchInMultipleResults.
Benefits
- CRM data in your SQL Server reports. Dynamics 365 tables land next to finance and operations data, where Power BI and SQL queries can join them.
- No password in the package. OAuth sign-in, with your own Azure AD app if your security team wants it, keeps service passwords out of SSIS.
- Two-way sync in the tool you have. No separate integration service to buy or host: the same SSIS catalog and SQL Server Agent jobs run it.
- Fewer API calls. Batched destinations and a caching lookup keep large jobs within Dynamics 365's API limits.
Real-World Uses
- CRM reporting warehouse. A nightly package copies accounts, opportunities and activities into SQL Server for sales dashboards.
- ERP to CRM sync. Customer and product records maintained in an on-premises ERP are pushed into Dynamics 365 so sales sees current prices and credit status.
- Data migration. Records from an old CRM database are loaded into Dynamics 365 tables, with lookups matching existing accounts first.
- Data cleanup. Duplicate or stale contacts found by SQL queries in the warehouse are updated or deleted in Dynamics 365 in one batch.
Who It's For, and Who Should Skip It
It's for organisations that run SQL Server Integration Services and need Dynamics 365 data in or out on a schedule, especially when IT wants OAuth sign-in rather than stored passwords.
Skip it if you don't use SSIS: these are SSIS components, not a standalone sync service. If you need Dynamics 365 alongside Salesforce, NetSuite or other sources, the SSIS Universal Bundle covers them all for $499.95 a year. And if your company is standardising on Azure Data Factory or Power Platform dataflows, an SSIS-only connector won't follow you there.
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.
- Add the connection. In an Integration Services project, add a Devart Dynamics 365 connection manager and enter your environment URL.
- Sign in. Choose OAuth, click Sign In, log in to Dynamics 365 in the web window, tick the consent box for your organisation if asked, and accept. Or tick Use custom OAuth App first and enter your own Azure AD app's Client ID and Secret.
- Query. Drop the Devart Dynamics 365 Source into a data flow, pick a table, write or drag in the SELECT, and preview the rows.
- Load and match. Send rows to the Destination with the Insert, Update or Delete action, or use the Lookup to find existing records. Deploy and schedule the package like any other.
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
- No upsert action. The Destination offers INSERT, UPDATE and DELETE; picking an upsert operation gives an error, so insert-or-update logic needs a Lookup and a split in the data flow.
- OAuth edge cases. Sign-in for tenants that require administrator consent only got fixed in 5.1.49, so older installs may need updating, and your Azure AD admin may have to approve the app.
- Complex queries pull data locally. SELECTs the API can't run are processed after the data is fetched, which can be slow on big tables.
- 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 Dynamics 365 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 Dynamics 365 account before deciding.
Comparisons
SSIS Data Flow Components for Dynamics 365 vs SSIS Universal Bundle
Devart's SSIS Universal Bundle includes this Dynamics 365 connector plus components for Salesforce, NetSuite, QuickBooks Online, HubSpot, SQL Server, Oracle, 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 Dynamics 365 alone. If you'll need three or more Devart connectors, the bundle costs less than buying them one by one.
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
Is SSIS Data Flow Components for Dynamics 365 the same as Devart's Dynamics CRM components?
Yes. SSIS Data Flow Components for Dynamics 365 is the product Devart sold as SSIS Data Flow Components for Microsoft Dynamics CRM; it was renamed in version 2.1.411 in July 2023.
Can SSIS Data Flow Components for Dynamics 365 use our own Azure AD app for sign-in?
Yes. SSIS Data Flow Components for Dynamics 365's OAuth sign-in accepts a custom Client ID and Client Secret from an app registered in your Azure AD tenant; otherwise it uses Devart's Microsoft-signed app.
Does SSIS Data Flow Components for Dynamics 365 work behind a proxy?
Yes. SSIS Data Flow Components for Dynamics 365's connection manager has proxy host, port (3128 by default), user and password settings.
Does SSIS Data Flow Components for Dynamics 365 work with SSIS 2008?
No. SSIS Data Flow Components for Dynamics 365 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 Dynamics 365 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 Dynamics 365 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 Dynamics 365?
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 Microsoft Dynamics 365 environment and an account with access to the tables you use
Conclusion
SSIS Data Flow Components for Dynamics 365 is worth $199.95 a year (or $399.95 once) for a team that runs SSIS and has to keep Dynamics 365 and SQL Server in step. The one reason to buy it is SQL access to every Dynamics 365 table, with writes back and OAuth sign-in, inside the packages and schedules you already have. The main reasons to hold back are the missing upsert action and the separate Server license production needs; and if Dynamics 365 is only one of several cloud systems you connect, the $499.95 Universal Bundle is the better buy. Test it against your own environment in the 30-day trial.
Download Free TrialBuy Now