SSIS Azure Table Storage Source
Extract large volumes of data from Azure Table Storage with SQL-like queries, no Azure API code needed.
Azure Table Storage Source extracts large volumes of data from Azure Table Storage, Microsoft’s cloud-based NoSQL data store. It supports a SQL-like query language, so you can query table data without dealing with the complex Azure API.
The trial includes Azure Table Storage Source and every other PowerPack component
- Data Flow Source in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial
At a glance
What Azure Table Storage Source can do
Azure Table Storage Source can be used to extract large amount of data from Azure Table Storage. This component supports SQL like query language to query Azure Table Storage data without worrying about complex API. Azure Table Storage is a cloud based NoSQL data storage service from Microsoft Azure
Bulk extract table data
Extract a large amount of data from Azure Table Storage, the NoSQL data storage service from Microsoft Azure.
SQL-like queries
Query Azure Table Storage with SQL; a lightweight parser turns it into a native Azure Table Storage query.
SELECT TOP n, column list,FROMandWHERE- Operators: =, != / <>, <, >, <=, >=
- AND or OR (one type per filter)
Typed query values
Filter on date/time, GUID, Int64 and Boolean attributes.
datetime'2015-01-01', with Z suffix for UTCguid'...',Lsuffix for Int64,true/false
Dynamic queries
Use SSIS variables inside the query to make it dynamic.
- e.g.
WHERE Country = '{{User::varCountry}}' - Date variables with a format, e.g.
{{User::varMyDate,yyyy-MM-ddZ}}
Table or query mode
Read a whole table picked from a dropdown, or run a SQL query.
AccessMode: Table or Query- Data preview for both modes
Batch size control
Set how many records are processed in a single request.
BatchSizeproperty; 0 extracts all records in a single request
Error output
Capture bad rows along with the exact reason of the error.
- Redirect rows on error or truncation from the error handling tab
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
Azure Storage connection
Connect through the Azure Storage Connection Manager with an account name and access key, a SAS URL or token, a connection string, or the local Azure Storage Emulator.
- Custom Blob, Table and Queue endpoints
- Proxy settings, plus
Timeout,MaxRetryOnErrorandRetryInterval
See all features
- Bulk extract/output Azure Table Storage data
- SQL-like queries using a proprietary query engine, no need to learn complex Azure APIs
- TOP clause, column list and WHERE conditions with comparison operators
- Query date/time, GUID, Int64 and Boolean attributes
- Dynamic queries with SSIS variable placeholders
- Table mode or Query mode
- Data preview
- Batch size setting for records processed in a single request
- Error output to redirect bad rows on error or truncation
- Connect with access key, SAS URL/token, connection string or the Azure Storage Emulator
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Key steps from the Azure Table Storage Source page and help file, with the screens you will see in SSDT.
Pick the connection and the access mode.
Double-click the source, select (or create) the Azure Storage connection, and set AccessMode to Table to read a whole table, or Query to run a SQL-like query.
AccessMode: Table or QueryBatchSizerecords per request (0 = all in one request)
Read a whole table and preview it.
With AccessMode set to Table, select the table from the Tables dropdown and click Preview to check the data before you connect a destination.
- Table picked from a dropdown
- Design-time data preview
Filter with familiar SQL.
With AccessMode set to Query, write SQL such as SELECT TOP 2 * FROM Customer WHERE CustomerID='ALFKI' OR CustomerID='BOLID'. A lightweight parser turns it into a native Azure Table Storage query.
TOP, column list andWHERE- =, !=/<>, <, >, <=, >= with AND or OR (not mixed)
- datetime, guid, Int64 (L) and Boolean values
Drive the filter from an SSIS variable.
Create a variable with the right data type and value, then reference it in the query, e.g. SELECT * FROM Customers WHERE Country = '{{User::varCountry}}'. Date variables take a format, e.g. datetime'{{User::varMyDate,yyyy-MM-ddZ}}'.
- Variable placeholders anywhere in the query
- Z suffix marks a UTC date/time
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the Azure Table Storage Source product page. Step through them, or open any shot at full size.
Azure Table Storage Source Settings
Select the connection and choose Table or Query access mode.
Articles
Worked examples that use Azure Table Storage Source.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop Azure Table Storage Source on the canvas.
What is Azure Table Storage Source?
A Data Flow source that extracts large volumes of data from Azure Table Storage, Microsoft’s cloud-based NoSQL data store. Read a whole table, or filter with a SQL-like query that is converted into a native Azure Table Storage query.
Which SQL syntax is supported?
SELECT [TOP n] columns FROM table [WHERE ...] with =, != or <>, <, >, <= and >=. Conditions can be joined with AND or with OR, but not both in one filter. Use square brackets for names with spaces, e.g. [Contact Title]. See the query language reference.
How do I filter on dates, GUIDs, Int64 or Boolean values?
Use datetime'2015-01-01' (end with Z for UTC), guid'123223DB-A2CD-48BB-99ED-E3614A5EA97E', an L suffix for Int64 numbers (e.g. 9223372036854775787L), and true/false without quotes for Boolean attributes.
Can the query use SSIS variables?
Yes. Put placeholders in the query, e.g. WHERE Country = '{{User::varCountry}}', or for dates datetime'{{User::varMyDate,yyyy-MM-ddZ}}'.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
See also
More from SSIS PowerPack.
What customers say
Start your free trial today
Install SSIS PowerPack and drag Azure Table Storage Source onto the Data Flow.
Extract large volumes of data from Azure Table Storage with SQL-like queries, no Azure API code needed.
- Data Flow Source in SSISAzure Table Storage Source appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.