Included in SSIS PowerPack

SSIS Secure FTP CSV File Source

Read CSV files from FTP, SFTP and FTPS servers.

SSIS Secure FTP Source for CSV files can be used to read CSV files from Secure FTP Storage (Using FTP, SFTP, FTPS or FTP/SSL Protocols). You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk.

Download Free Trial Buy Now

The trial includes Secure FTP CSV File Source and every other PowerPack component

Help & Docs
Secure FTP CSV File Source in SSDT
Secure FTP CSV File Source editor with Secure FTP connection, remote file path and data preview
Pick the Secure FTP connection, browse to the CSV file and preview rowsExplore 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 Secure FTP CSV File Source can do

SSIS Secure FTP Source for CSV files can be used to read CSV files from Secure FTP Storage (Using FTP, SFTP, FTPS or FTP/SSL Protocols). 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 one or many files

Read a single CSV file or many files from Secure FTP storage using a wildcard pattern such as *.csv.

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

Read SFTP / FTP files guide

Compressed files in stream mode

Read zip and gzip compressed CSV files without extracting them on disk.

  • FileCompressionType: GZip, Zip or TarGZip

Component properties

FTP, SFTP & FTPS connections

Connect with Classic FTP, SFTP or FTPS (FTP over SSL/TLS) through the Secure FTP Connection Manager.

  • Logon with user name and password, private key file, X509 certificate, Kerberos or NTLM
  • FTPS implicit or explicit encryption, SSL 3.0 to TLS 1.3
  • Proxy support: SOCKS4, SOCKS4a, SOCKS5 or HTTP CONNECT

Connection Manager help

Advanced CSV parsing

Fine-tune how each CSV file is parsed.

  • Custom ColumnDelimiter, including hex codes such as \x0009 for Tab
  • TrimFields, TrimHeaders, SkipRows and SkipHeaderCommentRows
  • Comment lines (AllowComment) and custom quote character

Component properties

Blank & missing values

Handle missing columns, blank lines and empty values cleanly.

  • Missing columns at the end of a row are filled with nulls
  • IgnoreBlankLines and SkipEmptyRecords
  • TreatBlankAsNull plus blank-as-null for number, bool and date types

Component properties

Error handling

Decide what happens when files or rows are not as expected.

  • ThrowErrorOnNoRecordFound and ThrowErrorOnColumnCountMismatch
  • Redirect bad records to the error output
  • ContinueOnFileNotFoundError to skip missing files

See the screenshots

Pivot columns into rows

Turn columns into rows so each value is output in a separate row.

  • EnablePivot outputs Pivot_Name and Pivot_Value columns
  • IncludePivotPath adds a Pivot_Path column

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

Data types & date parsing

Control how data types, lengths, dates and numbers are detected.

  • MetaDataScanMode: Auto, Strict, Guess2x to Guess10x, all-string or MAX-length options
  • DateParseHandling: keep as string, DateTime or DateTimeOffset
  • Culture and FloatParseHandling (Decimal for high precision)

Component properties

See all features
  • Read single or multiple CSV files stored in Secure FTP storage (wildcard pattern such as *.csv)
  • Read zip and gzip compressed files in stream mode, without extracting them on disk
  • Support for FTP (Classic FTP), SFTP, FTPS or FTP/SSL protocols
  • Dynamic file path using variable placeholders (e.g. /myroot/{{User::MyFolder}}/*.csv)
  • Missing columns at the end of a row are auto-filled with null values
  • Data pivot (transform columns into rows)
  • Support for comment lines in the file
  • Error options such as throw error for an empty file or when the column count does not match
  • Parser options such as trim fields, trim headers and skip rows
  • Ignore blank lines and blank rows (no data in any column)
  • Encoding and character set options for the source file
  • Custom search / replace (including regular expressions) before the text is parsed
  • Output the file path and file name as extra columns (__FilePath, __FileName)
  • Design-time data preview and redirect of bad records to the error output

  • 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 Secure FTP CSV File Source page and help file, with the screens you will see in SSDT.

Pick the connection and remote file, then preview rows.

Select a Secure FTP connection, click the browse button to pick a remote file (or type a path such as /In/*.csv), tick First row has column headers and click Preview.

  • Single file or wildcard pattern, with optional sub-folder scan
  • Output __FilePath / __FileName columns
  • Continue on missing file instead of failing
Secure FTP CSV File Source settings: connection, remote path, header option and data preview

Inside the UI

Key settings, as they appear in SSDT.

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

Read from CSV file options

Select the Secure FTP connection, browse to the remote CSV file, tick First row has column headers and click Preview to check the rows.

Articles

Worked examples that use Secure FTP CSV File Source.

GuideRead SFTP / FTP files in SSIS (CSV, JSON, XML)Read single files, wildcard sets and zip/gzip files from FTP or SFTP and load them into SQL Server.zappysys.com blogRead articleGuideDownload the latest file from FTP (SFTP / FTPS)Get the remote file list, find the newest file and set its path in a variable.zappysys.com blogRead articleGuideSSIS SFTP task examplesUpload, download, move and delete files and folders on FTP, SFTP and FTPS servers with the Secure FTP Task.zappysys.com blogRead articleCollectionAll Secure FTP CSV File Source articlesMore tutorials from the ZappySys blog.zappysys.com blogBrowse all articles

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 Secure FTP CSV File Source on the canvas.

What is Secure FTP CSV File Source?

A Data Flow Source in SSIS PowerPack that reads CSV files stored on an FTP, SFTP or FTPS (FTP over SSL/TLS) server. It reads one file or many files with a wildcard pattern, and can read compressed (zip / gzip) files without extracting them on local disk.

Which protocols and logon types does it support?

It uses the Secure FTP Connection Manager: Classic FTP, SFTP (SSH File Transfer Protocol) and FTPS with implicit or explicit TLS/SSL. Logon can use user name and password, a private key file, an X509 certificate, Kerberos or NTLM, and the connection supports SOCKS4, SOCKS4a, SOCKS5 or HTTP CONNECT proxies.

Can I read many files at once?

Yes. Use a wildcard path such as /In/*.csv, turn on Recursive to include sub folders, and add the __FilePath / __FileName output columns to see which file each row came from. Paths can also contain SSIS variable placeholders, e.g. /myroot/{{User::MyFolder}}/*.csv.

Can it read zip or gzip files directly?

Yes. Set FileCompressionType to GZip, Zip or TarGZip and the file is decompressed in stream mode while it is read, without extracting it on disk.

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 Secure FTP CSV File Source onto the Data Flow.

Read single files, wildcard sets or zip/gzip archives from FTP, SFTP and FTPS servers, without extracting files on local disk.

  • Data Flow Source in SSISSecure FTP 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.
Download Free TrialView Pricing

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.

+1-800-444-5602Contact supportSSIS PowerPack overview

1 / 9