SSIS Amazon S3 XML File Source Connector

SSIS Amazon S3 Source for XML File

SSIS Amazon S3 Source for XML File can be used to read XML files from Amazon S3 Storage (i.e. AWS S3 Service). 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 Amazon S3 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 Amazon S3 related articles
  • Click here to see XML related articles
SSIS Amazon S3 XML File Source Connector - Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

SSIS Amazon S3 XML File Source – Read from XML File Options

SSIS Amazon S3 XML File Source - Read from XML File Options

SSIS Amazon S3 XML File Source – Read from XML File Options

SSIS Amazon S3 XML File Source – Create Azure Storage Connection

SSIS Amazon S3 XML File Source - Create Azure Storage Connection

SSIS Amazon S3 XML File Source – Create Azure Storage Connection

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

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

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

SSIS Amazon S3 XML File Source – Read Compressed XML File (GZip or Zip)

SSIS Amazon S3 XML File Source - Read Compressed XML File (GZip or Zip)

SSIS Amazon S3 XML File Source – Read Compressed XML File (GZip or Zip)

SSIS Amazon S3 XML File Source – DateTime Parsing Options

SSIS Amazon S3 XML File Source - DateTime Parsing Options

SSIS Amazon S3 XML File Source – DateTime Parsing Options

SSIS Amazon S3 XML File Source – Design time data preview

SSIS Amazon S3 XML File Source - Design time data preview

SSIS Amazon S3 XML File Source – Design time data preview

SSIS Amazon S3 XML File Source – Redirect Bad Records (Error Handling)

SSIS Amazon S3 XML File Source - Redirect Bad Records (Error Handling)

SSIS Amazon S3 XML File Source – Redirect Bad Records (Error Handling)

Articles / Tutorials

Click here to see all articles for [SSIS Amazon S3 XML Source] category


Read Amazon S3 Storage Files in SSIS (CSV, JSON, XML)

Read Amazon S3 Storage Files in SSIS (CSV, JSON, XML)

Introduction In our previous blog we saw how to load data into Amazon S3. Now in this blog, we will see How to read Amazon S3 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 […]

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