Included in SSIS PowerPack

SSIS Secure FTP CSV File Destination

Write CSV files straight to FTP, SFTP and FTPS servers.

SSIS Secure FTP CSV File Destination can be used to write data in CSV file format to Secure FTP Storage. You can automatically split large files by row count or size at runtime. It also supports writing files directly in compressed format such as GZip (*.gz).

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

Secure FTP CSV File Destination in SSDT
Secure FTP Connection Manager with SFTP protocol, host, port, user name and password
Create the Secure FTP connection: protocol, host, port and logonExplore 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 Destination can do

SSIS Secure FTP CSV File Destination can be used to write data in CSV file format to Secure FTP Storage. You can automatically split large files by row count or size at runtime. It also supports writing files directly in compressed format such as GZip (*.gz).

Write CSV straight to FTP

Create CSV files directly on Secure FTP storage from any source, such as SQL Server, Oracle or MySQL, without creating local files.

  • Use any Data Flow transformation before writing
  • Pick the columns to write on the Input Columns tab

SQL Server to FTP/SFTP guide

Split large files

Automatically split large output into multiple files at runtime.

  • EnableFileSplit with FileSplitMode ByRowCount or BySize
  • MaxRowsPerFile or MaxSizePerFile (e.g. 100mb)

Component properties

Compressed output

Write files directly in compressed format in stream mode.

  • CompressionType: GZip, Zip or TarGZip
  • Add the matching extension (e.g. *.gz) to the file path

Component properties

Dynamic file paths

Build the target path at runtime with variable placeholders or a variable.

  • e.g. myroot/folder/file_{{System::StartTime,yyyyMMdd}}.dat
  • AccessMode Variable with FilePathVariable

Component properties

Delimiters & quoting

Shape the CSV layout to match the target system.

  • ColumnDelimiter and RowDelimiter accept {TAB}, {CRLF} or hex codes such as \xNN
  • QuotesAroundValue with a custom QuoteChar
  • FirstRowHasColumnNames and DateTimeFormat

Component properties

Append & overwrite control

Choose how existing and empty files are handled.

  • Append or OverwriteFileIfExists
  • DoNotCreateFileIfNoRows skips empty files when there are no input rows

Component properties

Encoding & escape rules

Set the output encoding and replace special characters with custom rules.

  • Encoding (UTF-8, UTF-16, with or without BOM) or CharacterSet (e.g. ISO-8859-1)
  • EnableCustomEscapeSequence with CustomEscapeSequenceRule

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

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 and MaxUploadSpeedKbps throttling

Connection Manager help

See all features
  • Create CSV files directly in Secure FTP from any source (e.g. SQL Server, Oracle, MySQL) without creating local files
  • Create compressed files in stream mode (GZip, Zip or TarGZip)
  • Support for FTP (Classic FTP), SFTP, FTPS or FTP/SSL protocols
  • Split files by row count or file size
  • Variable placeholders anywhere in the file path, or read the path from a variable
  • Custom column and row delimiters, including hex codes and special values such as {TAB}
  • Optional quotes around values with a custom quote character
  • Optional header row with column names
  • Custom date/time format for date columns
  • Append to or overwrite existing files
  • Option to not create a file when there are no input rows
  • Encoding and character set options
  • Custom escape sequence rules to replace special characters
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix
  • 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 Destination page and help file, with the screens you will see in SSDT.

Create a Secure FTP connection.

Add a ZS-SFTP connection manager, choose the protocol (SFTP, FTP or FTPS), enter the host name and logon details, then click Test Connection.

  • Password, private key file, X509 certificate, Kerberos or NTLM logon
  • FTPS with implicit or explicit TLS/SSL
  • Proxy support and upload speed limit (MaxUploadSpeedKbps)
Secure FTP Connection Manager with SFTP protocol, host and user name and password logon

Inside the UI

Key settings, as they appear in SSDT.

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

Create a Secure FTP connection

Choose the protocol (SFTP, FTP or FTPS), enter host and port, pick a logon type such as user name and password, then Test Connection.

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 Destination on the canvas.

What is Secure FTP CSV File Destination?

A Data Flow Destination in SSIS PowerPack that writes data in CSV format directly to an FTP, SFTP or FTPS server from any source (e.g. SQL Server, Oracle, MySQL), without creating local files. It can split large output by row count or size and write GZip or Zip compressed files.

How do I split a large export into several files?

Set EnableFileSplit to True and choose FileSplitMode ByRowCount with MaxRowsPerFile, or BySize with MaxSizePerFile (e.g. 100mb). See the SQL Server to FTP/SFTP guide.

Can the file name be dynamic?

Yes. Use variable placeholders anywhere in FilePath, e.g. myroot/folder/file_{{System::StartTime,yyyyMMdd}}.dat, or set AccessMode to Variable and supply the path in FilePathVariable.

Which protocols and logon types does it support?

It uses the Secure FTP Connection Manager: Classic FTP, SFTP and FTPS with implicit or explicit TLS/SSL, with user name and password, private key file, X509 certificate, Kerberos or NTLM logon.

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 Destination onto the Data Flow.

Create CSV files on FTP, SFTP and FTPS servers from any source, without local files, with compression and automatic split by row count or size.

  • Data Flow Destination in SSISSecure FTP CSV File Destination 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 / 4