SSIS Data Flow Components for MySQL
SSIS Data Flow Components for MySQL icon

SSIS Data Flow Components for MySQL

by Devart
$179.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 2008 to 2025, Visual Studio with SSIS projects, .NET Framework 4.5, MySQL 3.23 to 8.4 or MariaDB 5 to 12 (no MySQL client needed)
File Size
618.60 MB
Release Date
8/17/2026
Last Updated
11/18/2026
6 views 0 downloads
Devart SSIS Source, Destination and Lookup components for MySQL and MariaDB

SSIS Data Flow Components for MySQL: MySQL and MariaDB Source, Destination and Lookup for SSIS

Devart SSIS Data Flow Components for MySQL add a MySQL Source, Destination, Lookup and Connection Manager to SQL Server Integration Services, for $179.95 a year (Developer license) or $349.95 perpetual. They connect straight to MySQL 3.23 through 8.4, MariaDB 5 through 12, Percona, SingleStore and Amazon RDS and Aurora, with no MySQL ODBC driver or client library, and add SSH, SSL and HTTP tunneling to the connection.

Getting MySQL data in and out of SSIS normally means installing MySQL's ODBC driver on every developer PC and server, then living with a generic ODBC source and slow row-by-row inserts. Devart's components replace that with a MySQL-specific connection manager, a query editor that knows your schema, multi-row inserts and a caching lookup.

Quick facts

  • Version: 5.1.49, released August 17, 2026
  • Developer: Devart
  • Components: MySQL Source, MySQL Destination, MySQL Lookup, MySQL Connection Manager
  • Servers: MySQL 3.23 to 8.4, MariaDB 5, 10, 11 and 12, Percona, SingleStore, Amazon RDS for MySQL and MariaDB, Amazon Aurora
  • SSIS: SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 and 2025
  • Platform: Windows Vista or later, 32-bit and 64-bit, .NET Framework 4.5
  • Download: 618.60 MB installer shared with the whole SSIS line; needs a free Devart account
  • Price: $179.95 a year or $349.95 perpetual for a Developer license; Server and Site licenses cost more
  • Trial: 30 days, fully functional
  • Refund: Devart's ordering FAQ gives a refund within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $179.95 for the Developer license with one year of updates on a yearly subscription, and the download page listed version 5.1.49 at 618.60 MB, on November 18, 2026. We didn't run a package against a MySQL server

Download Free Trial Buy Now

Overview

After installation the MySQL components appear in the SSIS Toolbox in Visual Studio. You add a Devart MySQL Connection Manager with server, port (3306 by default), user, password and database, then drop a Source, Destination or Lookup into a Data Flow task. Everything else works like native SSIS: the components feed and accept ordinary data flow paths, so MySQL can sit on either side of a package next to SQL Server, flat files or any other source.

Devart MySQL Source Editor in Visual Studio with the sakila tables and a SELECT query

The Devart MySQL Source Editor inside Visual Studio: the table tree of the sakila sample database, the query pane and the package variables list.

Features

Connections through SSH, SSL or HTTP

The Devart MySQL Connection Manager in SSIS Data Flow Components for MySQL connects without a MySQL client and can tunnel through SSH or HTTP, encrypt with SSL and compress the data stream. Its Advanced options also cover character sets, GUID handling for BINARY(16) and CHAR columns, and connection pooling. Version 5.1.49 added PuTTY PPK3 SSH keys.

A Source editor that knows your schema

The MySQL Source in Devart SSIS Data Flow Components for MySQL lists every table and column of the connection, builds a SELECT by drag and drop, inserts package variables into the query and previews the returned rows, so you check the output before running the package.

Faster loading with multi-row inserts

The MySQL Destination in Devart SSIS Data Flow Components for MySQL inserts many rows per INSERT statement, can use INSERT DELAYED, and can lock the table while it loads, which beats row-by-row inserts through a generic ODBC destination.

A Lookup that batches and caches

The MySQL Lookup in Devart SSIS Data Flow Components for MySQL checks several incoming rows with one SELECT and caches the results, cutting round trips to the server.

MariaDB, SingleStore and the cloud

Devart SSIS Data Flow Components for MySQL support MariaDB up to version 12, Percona, Amazon RDS and Aurora, and since version 5.0 (June 2026) SingleStore, formerly MemSQL. The same release fixed a 'Bad handshake' error when opening connections.

Devart MySQL Connection Manager Editor with server, port, user, password and database

The Devart MySQL Connection Manager Editor's General tab: server, port 3306, user, password and database, with an Advanced tab for SSL, SSH and other options.

Benefits

  • No ODBC driver to deploy. One installer covers development PCs and SSIS servers.
  • Reach servers behind firewalls. SSH and HTTP tunneling are built into the connection.
  • Quicker loads. Multi-row inserts and optional table locking speed up big imports.
  • Old and new servers. One component set covers MySQL 3.23 to 8.4 and MariaDB 12.

Real-World Uses

  • MySQL to SQL Server migration. A package copies a web application's MySQL tables into SQL Server, the scenario in Devart's own video.
  • Nightly sync of a web shop. Orders from a MariaDB-backed store land in a SQL Server data warehouse every night.
  • Loading files into MySQL. A package reads CSV or XML exports and inserts them into MySQL tables.
  • Reaching a hosted database. A package connects to MySQL on a Linux host through an SSH tunnel without opening port 3306.

Who It's For, and Who Should Skip It

These components suit SQL Server teams that build ETL in SSIS and have MySQL or MariaDB on the other side, especially when the server sits behind SSH or the volumes make load speed matter.

Skip them if you don't use SSIS, or if you move small amounts of data occasionally: SSIS's ODBC components with MySQL's free Connector/ODBC can do that at no extra cost. If you'll connect to several systems, price the SSIS Universal Bundle first.

Usage Guide

  1. Sign in to Devart (a free account), download the installer from the product's download page and run it; select the MySQL components and the SSIS versions you use.
  2. Open an Integration Services project in Visual Studio. The Devart MySQL components appear in the SSIS Toolbox.
  3. In Connection Managers, add a new Devart MySQL connection: enter server, port, user, password and database, and open Advanced for SSL, SSH, HTTP tunneling or compression.
  4. Drag a Devart MySQL Source into a Data Flow task, pick objects in the editor or write a SELECT, and click Preview to check the rows.
  5. Connect it to a destination (or add a Devart MySQL Destination when loading into MySQL), map the columns and run the package.

Before you buy

The Developer license covers development and testing on one developer's machines only. Running packages on a production SSIS server needs a Server license ($449.95 a year or $899.95 perpetual) or a Site license, so budget for that from the start.

Where it falls short

  • Windows and SSIS only. No use outside SQL Server Integration Services.
  • Server licenses add up. Each production server needs its own Server license unless you buy a Site license.
  • Large download. The installer is over 600 MB even if you only want the MySQL components.
  • Few reviews. Only a dozen Capterra reviews cover the whole SSIS line.

What Users Say

Capterra

Review sites rate Devart's SSIS components as one product line rather than the MySQL components alone. On Capterra, SSIS Data Flow Components average 4.6 out of 5 from 12 reviews, with 4.3 for ease of use and 4.3 for customer service. Reviewers describe them as easy to set up inside Visual Studio and efficient for routine ETL work; the criticisms are occasional bugs, packages that become hard to maintain over time, and a wish for more help with troubleshooting. With so few ratings, test the trial on your own MySQL data before deciding.

Comparisons

MySQL components vs. the SSIS Universal Bundle

The SSIS Universal Bundle ($499.95 a year or $999.95 perpetual) includes components for more than 40 databases and cloud apps, MySQL among them. If you also connect to PostgreSQL, Oracle, Salesforce or similar, the bundle beats buying three single sources; for MySQL alone, these components cost far less.

Devart components vs. SSIS's ODBC source with MySQL Connector/ODBC

SSIS can reach MySQL through its built-in ODBC components and MySQL's free ODBC driver. Devart's components add multi-row inserts, a batching Lookup, a schema-aware Source editor and SSH and HTTP tunneling, and remove the driver from every machine. Pay for them when load speed, tunneling or package-building time matters.

Editions and Pricing

License1-year subscriptionPerpetualWhat it covers
Developer$179.95$349.95One developer's machines, for development and testing
Server$449.95$899.95One server running packages, plus one developer
Site for 10-100 DevicesOn the order page$999.95Unlimited computers in one company

Buy Now opens the order page for SSIS Data Flow Components for MySQL; you choose the license, subscription or perpetual, a 1-, 2- or 3-year term and optional premium support there. The SSIS Universal Bundle, with components for more than 40 sources, costs $499.95 a year or $999.95 perpetual on Devart's page.

FAQs

Do Devart's SSIS components for MySQL work with MariaDB?

Yes. Devart SSIS Data Flow Components for MySQL support MariaDB versions 5, 10, 11 and 12, as well as Percona, SingleStore and Amazon RDS and Aurora.

Do I need MySQL Connector/ODBC installed?

No. Devart SSIS Data Flow Components for MySQL connect directly with their own connection manager, so no ODBC driver or MySQL client library is needed.

Can the MySQL connection go through an SSH tunnel?

Yes. The Devart MySQL Connection Manager in SSIS Data Flow Components for MySQL supports SSH, SSL and HTTP tunneling, and version 5.1.49 added PuTTY PPK3 keys.

Which SSIS versions do the MySQL components work with?

Devart SSIS Data Flow Components for MySQL work with SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 and 2025.

Do I need a separate license for the production SSIS server?

Yes. The Developer license of SSIS Data Flow Components for MySQL covers development and testing only; deploying packages to a server needs a Server license or a Site license.

What happens when the subscription ends?

The subscription license of SSIS Data Flow Components for MySQL 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.

Can I get a refund?

Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops SSIS Data Flow Components for MySQL working and support can't fix it. Use the 30-day trial against your own MySQL database before buying.

System Requirements

  • Microsoft SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 or 2025
  • Visual Studio with Integration Services projects for designing packages
  • Windows Vista or later, 32-bit or 64-bit, with .NET Framework 4.5
  • MySQL 3.23 to 8.4, MariaDB 5 to 12, Percona, SingleStore or Amazon RDS/Aurora

Conclusion

Devart SSIS Data Flow Components for MySQL are worth $179.95 a year to a team that runs SSIS packages against MySQL or MariaDB and wants direct connections with SSH tunneling, faster multi-row loading and a caching Lookup without installing an ODBC driver everywhere. Add a Server license for production. For occasional small transfers, SSIS's ODBC components with the free MySQL driver will do, and if MySQL is one of many sources, the Universal Bundle is better value.

Download Free Trial Buy 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.

Related Videos
How to migrate data from MySQL to SQL Server using SSIS
How to migrate data from MySQL to SQL Server using SSIS

Video Length: 02:41
Uploaded By: Devart (9/10/2025)
View Count: 683

Copyright © 2026, Ivertech. All rights reserved.