SSIS Data Flow Components for Snowflake
SSIS Data Flow Components for Snowflake icon

SSIS Data Flow Components for Snowflake

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 2012 to 2025, Visual Studio with SSIS projects, .NET Framework 4.5, a Snowflake account, Amazon S3 or Azure Blob Storage for bulk loads
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 Snowflake

SSIS Data Flow Components for Snowflake: Load and Read Snowflake in SSIS

Devart SSIS Data Flow Components for Snowflake add a Snowflake Source, Destination, Lookup and Connection Manager to SQL Server Integration Services, for $179.95 a year (Developer license) or $349.95 perpetual. They connect to Snowflake with a password or OAuth, read with a schema-aware query editor, and load large volumes by staging CSV files in Amazon S3 or Azure Blob Storage and running Snowflake's COPY command.

Snowflake's ODBC driver works in SSIS, but row-by-row inserts into a cloud warehouse are painfully slow, and staging files yourself means extra tasks in every package. Devart's Snowflake Destination does the staging and COPY for you, and the Source and Lookup are built for Snowflake's SQL.

Quick facts

  • Version: 5.1.49, released August 17, 2026
  • Developer: Devart
  • Components: Snowflake Source, Snowflake Destination, Snowflake Lookup, Snowflake Connection Manager
  • Snowflake: Snowflake API, data types and standard SQL; bulk loads staged through Amazon S3 or Azure Blob Storage
  • SSIS: SQL Server Integration Services 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 Snowflake account

Download Free Trial Buy Now

Overview

After installation the Snowflake components appear in the SSIS Toolbox in Visual Studio. You add a Devart Snowflake Connection Manager with your account domain, user, password and database (plus warehouse, schema and role if needed), 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 Snowflake can sit on either side of a package next to SQL Server, flat files or any other source.

Devart Snowflake Source Editor with a Preview Data window showing contact rows

The Devart Snowflake Source Editor with a SELECT on the contact table and the Preview Data window showing the first 100 rows.

Features

Bulk loading through cloud storage

The Snowflake Destination in Devart SSIS Data Flow Components for Snowflake splits the incoming data into multiple CSV files, uploads them to Amazon S3 or Azure Blob Storage, and then runs Snowflake's COPY command to import them, the fastest way to load large volumes. Ordinary Insert, Update and Delete operations work too without any storage account.

Password or OAuth sign-in

The Devart Snowflake Connection Manager in SSIS Data Flow Components for Snowflake supports user and password or OAuth 2.0 with a client ID and secret from a Snowflake security integration, plus warehouse, schema and role settings, connection pooling and a proxy server.

A Source editor with preview

The Snowflake Source in Devart SSIS Data Flow Components for Snowflake lists your tables and columns alongside the package's system and user variables, builds queries by drag and drop and runs them to preview the returned rows.

A Lookup that batches and caches

The Snowflake Lookup in Devart SSIS Data Flow Components for Snowflake checks multiple rows with one SELECT and caches the results, cutting round trips to the warehouse.

Recent fixes

Devart SSIS Data Flow Components for Snowflake 5.1.49 fixed reading JSON from VARIANT columns and an 'invalid identifier' error in the Destination, and 5.0 added newer Amazon S3 regions for staging.

Devart Snowflake Connection Manager Editor with domain, user, database, warehouse, schema and role fields

The Devart Snowflake Connection Manager Editor: domain, user, password, database, warehouse, schema and role, with the advanced pooling and proxy options on the right.

Benefits

  • Fast loads without extra tasks. Staging and COPY happen inside one Destination.
  • No Snowflake ODBC driver. One installer for developer PCs and servers.
  • Uses familiar SSIS. SQL Server teams load Snowflake with the tool they already know.

Real-World Uses

  • SQL Server to Snowflake migration. A package moves warehouse tables from SQL Server into Snowflake, the scenario in Devart's own video.
  • Nightly warehouse loads. Millions of rows from on-premises systems land in Snowflake through S3 staging every night.
  • Pulling Snowflake data back. A package reads aggregated Snowflake tables into SQL Server for local reporting.
  • Lookups against dimension tables. The Lookup enriches rows with keys from Snowflake dimensions.

Who It's For, and Who Should Skip It

These components suit SQL Server shops that build ETL in SSIS and load or read Snowflake, especially at volumes where bulk loading matters.

Skip them if you don't use SSIS: Snowflake's own tools, Python or a cloud ETL service fit better outside the Microsoft stack. For small occasional transfers, SSIS with Snowflake's free ODBC driver may be enough.

Usage Guide

  1. Sign in to Devart (a free account), download the installer from the product's download page and run it; select the Snowflake components and the SSIS versions you use.
  2. Open an Integration Services project in Visual Studio. The Devart Snowflake components appear in the SSIS Toolbox.
  3. In Connection Managers, add a new Devart Snowflake connection: enter the account domain, user, password and database, plus warehouse, schema and role if needed, or choose OAuth under Advanced.
  4. Drag a Devart Snowflake 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 Snowflake Destination when loading into Snowflake), 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. Fast bulk loading needs an Amazon S3 bucket or Azure Blob Storage account for staging, set up in the Destination's editor.

Where it falls short

  • Staging storage needed for speed. Bulk loads go through S3 or Azure Blob Storage, which you must provide.
  • No key-pair sign-in listed. The connection manager offers password and OAuth.
  • Windows and SSIS only. No use outside SQL Server Integration Services.
  • Large download. The installer is over 600 MB.

What Users Say

Capterra

Review sites rate Devart's SSIS components as one product line rather than the Snowflake 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 Snowflake data before deciding.

Comparisons

Snowflake components vs. the SSIS Universal Bundle

The SSIS Universal Bundle ($499.95 a year or $999.95 perpetual) includes Snowflake along with more than 40 other sources. If you also connect to Salesforce, HubSpot, MySQL or similar, the bundle is the better deal; for Snowflake alone, these components cost far less.

Devart components vs. SSIS with Snowflake's ODBC driver

Snowflake's ODBC driver is free and works with SSIS's ODBC source and destination, but inserts row by row. Devart's components add staged bulk loading with COPY, a batching Lookup and a Source editor with preview. Pay for them when load volume 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 Snowflake; 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 I need an S3 bucket to load data into Snowflake with Devart?

Only for high-performance loading. Devart SSIS Data Flow Components for Snowflake can insert, update and delete without storage, but bulk loading stages files in Amazon S3 or Azure Blob Storage before running COPY.

Does it support OAuth for Snowflake?

Yes. The connection manager in Devart SSIS Data Flow Components for Snowflake supports OAuth 2.0 with a client ID and secret from a Snowflake security integration, as well as user and password.

Can it read VARIANT columns?

Yes. Devart SSIS Data Flow Components for Snowflake read VARIANT data, and version 5.1.49 fixed reading JSON-structured values from VARIANT columns.

Which SSIS versions do the Snowflake components work with?

Devart SSIS Data Flow Components for Snowflake work with SQL Server Integration Services 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 Snowflake 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 Snowflake 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 Snowflake working and support can't fix it. Use the 30-day trial against your own Snowflake account before buying.

System Requirements

  • Microsoft SQL Server Integration Services 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
  • A Snowflake account, plus Amazon S3 or Azure Blob Storage for bulk loading

Conclusion

Devart SSIS Data Flow Components for Snowflake are worth $179.95 a year to SSIS teams that load serious volumes into Snowflake: the Destination's staged COPY loading alone saves building that plumbing by hand. Add a Server license for production and have an S3 or Azure storage account ready. For small, occasional transfers, Snowflake's free ODBC driver will do, and if Snowflake is one of several 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 Snowflake to SQL Server using SSIS
How to migrate data from Snowflake to SQL Server using SSIS

Video Length: 03:08
Uploaded By: Devart (9/11/2025)
View Count: 482

How to migrate data from HubSpot to SnowFlake using SSIS
How to migrate data from HubSpot to SnowFlake using SSIS

Video Length: 16:21
Uploaded By: Learn SSIS (10/14/2024)
View Count: 646

Copyright © 2026, Ivertech. All rights reserved.