Included in SSIS PowerPack

SSIS Amazon S3 CSV File Source

Read CSV files from Amazon S3 Storage.

SSIS Amazon S3 CSV File Source can be used to read CSV 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.

The trial includes Amazon S3 CSV File Source and every other PowerPack component

Amazon S3 CSV File Source in SSDT
Amazon S3 CSV File Source - Read from CSV File Options
Read CSV files from Amazon S3 StorageExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Amazon S3 CSV File Source can do

SSIS Amazon S3 CSV File Source can be used to read CSV 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.

Read many S3 files

Read a single file or multiple files stored in Amazon S3 using a wildcard pattern (e.g. *.csv).

  • Recursive includes files from sub folders
  • EnableMultiPathMode reads a list of paths in one step
  • Dynamic path with variable placeholders, e.g. /myroot/{{User::MyFolder}}/*.csv

Read S3 files tutorial

Read compressed files

Read Zip and GZip compressed files in stream mode, without extracting them on disk.

  • FileCompressionType: GZip, Zip or TarGZip

Component properties

Advanced CSV parsing

Fine-tune how the CSV file is parsed.

  • TrimFields, TrimHeaders, SkipRows, SkipHeaderCommentRows
  • AllowComment skips comment lines; IgnoreBlankLines and SkipEmptyRecords
  • Custom ColumnDelimiter and QuoteCharacter

Component properties

Error handling options

Choose when the source should fail and capture bad records.

  • ThrowErrorOnColumnCountMismatch and ThrowErrorOnNoRecordFound
  • Missing columns at the end are auto filled with null values
  • Redirect bad records to the error output

See the screenshots

Data pivot

Transform columns into rows with the pivot option.

  • EnablePivot outputs Pivot_Name and Pivot_Value columns

Component properties

Null, date & culture handling

Control how blank values, dates and numbers are converted.

  • TreatBlankAsNull, plus blank-as-null for number, bool and date types
  • Culture for culture specific number formats
  • Date/time parsing options

Component properties

Metadata & file info

Control how column data types are detected and add file details to the output.

  • MetaDataScanMode: Auto, Strict, Guess2x to Guess10x, or all strings
  • OutputFilePath / OutputFileName add __FilePath and __FileName columns
  • Design-time data preview

Component properties

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

Compatibility and requirements

Flexible AWS credentials

Connect through the Amazon Storage Connection Manager with access keys, temporary credentials or the default instance credentials.

  • CredentialType: key-based, temporary token (with SessionToken) or default (IAM Role or anonymous)
  • Proxy server support with optional proxy authentication
  • ForcePathStyle for S3-compatible services such as MinIO, Ceph or Cloudian

Connection Manager help

See all features
  • Read single or multiple files stored in Amazon S3 (wildcard pattern supported, e.g. *.csv)
  • Read Zip and GZip compressed files in stream mode
  • Dynamic file path using variable placeholders (e.g. /myroot/{{User::MyFolder}}/*.csv)
  • Missing columns at the end are auto filled with null values
  • Data pivot (transform columns into rows)
  • Comment lines in the file can be skipped
  • Error handling such as throw error for empty file or when column count mismatches
  • Advanced parser options such as trim fields, trim headers and skip rows
  • Ignore blank lines and blank rows (no data for each column)
  • Custom search/replace (including regex) before the data is parsed
  • Metadata scan modes to control detected data types and lengths
  • Output source file path and file name as columns
  • Server side and client side encryption using RSA/AES encryption keys
  • Key-based, temporary token or default (IAM Role) credentials, with proxy support
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Amazon S3 CSV File Source page and help file, with the screens you will see in SSDT.

Amazon S3 CSV File Source – Read from CSV File Options

Double-click ZS Amazon S3 CSV File Source, select your Amazon Storage connection and pick the S3 file with the file browser, or type a wildcard pattern (e.g. *.csv) to read many files at once.

Check First row has column headers if the file has a header, then click Preview to see the data.

Amazon S3 CSV File Source - Read from CSV File Options

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Amazon S3 CSV File Source product page. Step through them, or open any shot at full size.

Amazon S3 CSV File Source – Read from CSV File Options

Select the connection, choose the S3 file or a wildcard pattern, and set header options.

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 Amazon S3 CSV File Source on the canvas.

What is Amazon S3 CSV File Source?

SSIS Amazon S3 CSV File Source can be used to read CSV 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.

How do I read many CSV files from S3 in one go?

Use a wildcard pattern in the path (for example *.csv) and set Recursive to include sub folders. You can also turn on EnableMultiPathMode and list several paths separated by a new line or ::. Set OutputFileName or OutputFilePath to add __FileName / __FilePath columns so you know which file each row came from.

Can it read GZip or Zip files without extracting them?

Yes. Set FileCompressionType to GZip, Zip or TarGZip and the file is read in stream mode, without being extracted on local disk.

What happens with bad or incomplete rows?

Missing columns at the end of a row are filled with nulls. Turn on ThrowErrorOnColumnCountMismatch or ThrowErrorOnNoRecordFound to fail instead, or redirect bad records to the error output.

Can I read Amazon Athena query results?

Yes. Athena writes query output to S3 as CSV files, which this source can read. See Import / Export data from Amazon Athena using SSIS.

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.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Amazon S3 CSV File Source onto the Data Flow.

Read CSV files from Amazon S3 Storage.

  • Data Flow Source in SSISAmazon S3 CSV File 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.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 9