SSIS Azure Blob XML File Source Connector

SSIS Azure Blob Source for XML File

SSIS Azure Blob Source for XML File can be used to read XML files from Azure Blob Storage. You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk.

Features

  • Support for reading single or multiple files stored in Azure Blob Storage (wildcard pattern supported e.g. *.xml)
  • Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
  • Support for reading zip and gzip compressed files (stream mode)
  • Support for data pivot (transform columns into rows)
  • Support for Dynamic file path using variable placeholder (e.g. /myroot/{{User::MyFolder}}/*.xml )
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see Azure Blob related articles
  • Click here to see XML related articles
 SSIS Azure Blob XML File Source Connector - Video Tutorial
See also
Custom SSIS Components - Azure Blob CSV File Destination Azure Blob CSV File Destination
Custom SSIS Components - Azure Blob JSON File Source Azure Blob JSON File Source
Custom SSIS Components - Azure Blob XML File Source Azure Blob XML File Source
Custom SSIS Tasks - Azure Table Storage Source Azure Table Storage Source
Custom SSIS Tasks - Amazon S3 Storage Task Amazon S3 Storage Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Download Help File Buy View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

SSIS Azure Blob XML File Source – Read from XML File Options

SSIS Azure Blob XML File Source - Read from XML File Options

SSIS Azure Blob XML File Source – Read from XML File Options

SSIS Azure Blob XML File Source – Create Azure Storage Connection

SSIS Azure Blob XML File Source - Create Azure Storage Connection

SSIS Azure Blob XML File Source – Create Azure Storage Connection

SSIS Azure Blob XML File Source – Select XML File(s) using Blob Browser UI

SSIS Azure Blob XML File Source - Select XML File(s) using Blob Browser UI

SSIS Azure Blob XML File Source – Select XML File(s) using Blob Browser UI

SSIS Azure Blob XML File Source – Read Compressed XML File (GZip or Zip)

SSIS Azure Blob XML File Source - Read Compressed XML File (GZip or Zip)

SSIS Azure Blob XML File Source – Read Compressed XML File (GZip or Zip)

SSIS Azure Blob XML File Source – DateTime Parsing Options

SSIS Azure Blob XML File Source - DateTime Parsing Options

SSIS Azure Blob XML File Source – DateTime Parsing Options

SSIS Azure Blob XML File Source – Design time data preview

SSIS Azure Blob XML File Source - Design time data preview

SSIS Azure Blob XML File Source – Design time data preview

SSIS Azure Blob XML File Source – Redirect Bad Records (Error Handling)

SSIS Azure Blob XML File Source - Redirect Bad Records (Error Handling)

SSIS Azure Blob XML File Source – Redirect Bad Records (Error Handling)

Articles / Tutorials

Click here to see all articles for [SSIS Azure Blob XML Source] category


Read Azure Blob Storage Files in SSIS (CSV, JSON, XML)

Read Azure Blob Storage Files in SSIS (CSV, JSON, XML)

Introduction In our previous blog we saw how to load data into Azure Blob Storage. Now in this blog, we will see How to read Azure Blob Storage Files in SSIS (CSV, JSON, XML Format files). To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources to multiple destinations like […]

Click here to learn more about System Requirements
Download View All Tasks Like This