SSIS Data Flow Components for Google BigQuery
SSIS Data Flow Components for Google BigQuery icon

SSIS Data Flow Components for Google BigQuery

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, Google BigQuery, Google Cloud 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 Google BigQuery

SSIS Data Flow Components for Google BigQuery: BigQuery Source, Destination and Lookup for SSIS

Devart SSIS Data Flow Components for BigQuery add a BigQuery 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 Google BigQuery with OAuth, read with full BigQuery SQL support, and load data by uploading CSV files to Google Cloud Storage in parallel and having BigQuery import them.

Moving data between SQL Server and BigQuery in SSIS usually means a third-party ODBC driver and slow inserts, or a separate script to push files into Cloud Storage. Devart's BigQuery Destination handles the file staging and import itself, and the Source accepts BigQuery SQL of any complexity.

Quick facts

  • Version: 5.1.49, released August 17, 2026
  • Developer: Devart
  • Components: BigQuery Source, BigQuery Destination, BigQuery Lookup, BigQuery Connection Manager
  • BigQuery: Google BigQuery API, data types and standard SQL; loads staged through Google Cloud 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 BigQuery project

Download Free Trial Buy Now

Overview

After installation the BigQuery components appear in the SSIS Toolbox in Visual Studio. You add a Devart BigQuery Connection Manager, sign in to your Google account and pick the project and dataset, 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 BigQuery can sit on either side of a package next to SQL Server, flat files or any other source.

Devart BigQuery Source Editor with a Preview Data window showing client_id, transaction_id and revenue

The Devart BigQuery Source Editor with a SELECT on a dataset table and the Preview Data window showing the returned rows.

Features

Parallel bulk loading through Cloud Storage

The BigQuery Destination in Devart SSIS Data Flow Components for BigQuery splits the data into multiple CSV files, uploads them to Google Cloud Storage and tells BigQuery to import them, running these jobs in parallel. Its properties let you tune the batch and upload batch sizes.

Full BigQuery SQL in the Source

The BigQuery Source in Devart SSIS Data Flow Components for BigQuery accepts SQL of any complexity, and its editor lists tables and columns with the package's variables, builds queries by drag and drop and previews the returned rows.

Partition pseudocolumns and INTERVAL fixes

Devart SSIS Data Flow Components for BigQuery 5.1.49 added the _PARTITIONTIME and _PARTITIONDATE pseudocolumns for ingestion-time partitioned tables, so packages can read only recent partitions, and fixed an error when selecting from tables with INTERVAL columns.

A Lookup that batches and caches

The BigQuery Lookup in Devart SSIS Data Flow Components for BigQuery checks multiple rows with one SELECT and caches the results to reduce round trips.

OAuth sign-in and proxy support

The Devart BigQuery Connection Manager in SSIS Data Flow Components for BigQuery supports OAuth authentication and connecting through a proxy server.

Advanced Editor for Devart BigQuery Destination with BatchSize, BulkInsert and UploadBatchSize properties

The Devart BigQuery Destination's advanced properties: the Insert action, BatchSize, BulkInsert, UploadBatchSize and the target object name.

Benefits

  • Fast loads without scripts. Staging in Cloud Storage happens inside the Destination.
  • Cheaper reads. Partition pseudocolumns let a package scan only the partitions it needs.
  • One tool for both sides. SQL Server and BigQuery steps live in the same SSIS package.

Real-World Uses

  • Loading on-premises data into BigQuery. A nightly package pushes sales from SQL Server into a BigQuery dataset for Looker Studio dashboards.
  • Pulling analytics back. A package reads aggregated GA4 export tables from BigQuery into SQL Server.
  • Incremental reads. A package selects only yesterday's partition with _PARTITIONDATE.
  • Migrations. A team moves historical tables from SQL Server to BigQuery in SSIS.

Who It's For, and Who Should Skip It

These components suit SQL Server teams that use SSIS and need to load or read Google BigQuery regularly, particularly in larger volumes.

Skip them if you don't use SSIS: Google's own tools, Dataflow or a cloud ETL service fit better outside the Microsoft stack. For a one-time export, BigQuery's console or bq command-line tool may be all you need.

Usage Guide

  1. Sign in to Devart (a free account), download the installer from the product's download page and run it; select the BigQuery components and the SSIS versions you use.
  2. Open an Integration Services project in Visual Studio. The Devart BigQuery components appear in the SSIS Toolbox.
  3. In Connection Managers, add a new Devart BigQuery connection: sign in to Google with OAuth and choose the project and dataset; set a proxy under Advanced if needed.
  4. Drag a Devart BigQuery 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 BigQuery Destination when loading into BigQuery), 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. Bulk loading stages files in Google Cloud Storage, so plan for a bucket the components can write to.

Where it falls short

  • Cloud Storage needed for bulk loads. The Destination stages files in a bucket you provide.
  • BigQuery costs still apply. Queries are billed by data scanned.
  • 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 BigQuery 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 BigQuery data before deciding.

Comparisons

BigQuery components vs. the SSIS Universal Bundle

The SSIS Universal Bundle ($499.95 a year or $999.95 perpetual) includes BigQuery along with more than 40 other sources such as Google Analytics, Snowflake and Salesforce. If you need several, the bundle is the better deal; for BigQuery alone, these components cost far less.

Devart components vs. SSIS with a BigQuery ODBC driver

Google offers a BigQuery ODBC driver that works with SSIS's ODBC components, but loading row by row is slow. Devart's components add parallel staged loading, a BigQuery-aware Source editor with preview and a batching Lookup.

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 BigQuery; 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

How does Devart load data into BigQuery from SSIS?

Devart SSIS Data Flow Components for BigQuery split the data into CSV files, upload them to Google Cloud Storage and have BigQuery import them, in parallel.

Can it read only some partitions of a table?

Yes. Devart SSIS Data Flow Components for BigQuery 5.1.49 added the _PARTITIONTIME and _PARTITIONDATE pseudocolumns, so a query can filter on ingestion-time partitions.

Which SSIS versions do the BigQuery components work with?

Devart SSIS Data Flow Components for BigQuery 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 BigQuery 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 BigQuery 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 BigQuery working and support can't fix it. Use the 30-day trial against your own BigQuery project 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 Google Cloud project with BigQuery, plus a Cloud Storage bucket for bulk loading

Conclusion

Devart SSIS Data Flow Components for BigQuery are worth $179.95 a year to SSIS teams that move data into or out of BigQuery regularly: parallel staged loading and partition-aware reads save real time and money. Remember the Server license for production and a Cloud Storage bucket for loads. Outside SSIS, Google's own tools fit better, and with several cloud 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 Google BigQuery to SQL Server using SSIS
How to migrate data from Google BigQuery to SQL Server using SSIS

Video Length: 14:44
Uploaded By: Learn SSIS (1/10/2025)
View Count: 1,855

Copyright © 2026, Ivertech. All rights reserved.