SSIS SFTP Task (FTP, FTPS)
Move files over SFTP, FTPS, or classic FTP from your SSIS control flow.
Upload, download, delete, and list files using SFTP, FTP/SSL (FTPS), or classic FTP. Use wildcards or regex patterns for multiple files and authenticate with a password, private key, client certificate, NTLM, or Kerberos, all without coding.
The trial includes SFTP Task (FTP, FTPS) and every other PowerPack component
- SFTP, FTPS, and FTP
- Runs in your environment
- Server fingerprint and certificate verification
- Private key, certificate, Kerberos / NTLM
At a glance
What SFTP Task (FTP, FTPS) can do
SFTP Task performs many operations using SFTP, FTP/SSL (FTPS), or the classic FTP protocol. It supports many advanced options and authentication mechanisms such as NTLM, Kerberos, client certificate, and private key.
Three protocols
FTP (classic FTP), SFTP, and FTPS or FTP/SSL.
- Explicit or implicit FTP over SSL/TLS
- Public / private key for SSH file transfer
File operations
Common FTP file operations.
- Upload, download, delete, create, and rename files
- Get a single file property (name, size, exists status)
Folder operations
Common FTP directory operations.
- Create and delete folders
- Folder info list as an ADO.NET table
Wildcards & regex
Multi-file operations.
- Wildcard patterns such as
*.txt - Complex include / exclude patterns with regular expressions
Loop through files
File info list as an ADO.NET table.
- Loop with a ForEach Loop (ADO Enumerator)
- Path, Name, Size, and time columns
Security
Verify the server before sending credentials.
- SFTP server fingerprint verification
- SSL certificate thumbprint verification
- X509 client certificate, Kerberos / NTLM with single sign-on
Transfer options
Tune the transfer.
- ZLib compression for FTP, SSH compression for SFTP
- Restore timestamp after transfer
- Upload / download speed throttling
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
Proxy support
Proxy with advanced options.
- Socks4, Socks4a, Socks5, and HttpConnect proxy types
See all features
- FTP (classic FTP), SFTP, FTPS, or FTP/SSL protocols
- Public / private key for SSH file transfer
- Explicit / implicit FTP connection using SSL/TLS encryption
- Common FTP file operations: upload, download, delete, create, and rename files, get a file info list as an ADO.NET table (for looping with a ForEach Loop), get a single file property (e.g. name, size, exists status)
- Common FTP directory operations: create folder, delete folder, get a folder info list as an ADO.NET table
- SFTP server fingerprint verification and SSL certificate thumbprint verification before sending credentials or any other data
- Multi-file operations using a wildcard pattern or complex include / exclude patterns using regular expressions
- ZLib compression for FTP and SSH-based compression for SFTP
- Restore timestamp after file transfer
- X509 client certificate along with user ID / password authentication
- Kerberos / NTLM authentication with a single sign-on option
- Proxy with advanced options (Socks4, Socks4a, Socks5, HttpConnect)
- Upload / download speed throttling
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
Pick a storage action
Send, receive, clean up, or list.
Choose the storage action, a connection, and a path. Wildcards and regex filters decide which files are included.
Send files to the server.
Upload one or multiple files to the FTP server, with a built-in FTP file browser.
- Wildcard source path
- Create target folder if missing
Receive files from the server.
Download multiple files from the remote server with a simple wildcard (e.g. *.txt) or an advanced regex search pattern.
- Target path from a variable
- Option to delete source files after transfer
Include or exclude by pattern.
Include or exclude files from a local or remote search using regex and special conditions, with sorting, Top, Skip, and a Where condition.
- Include and exclude regex
- Sort by size or date
Clean up the server.
Delete multiple files from the FTP server. Use a wildcard or regex pattern to include or exclude files.
- Wildcard or regex selection
Create files and folders.
Create a file or folder, with SSIS variable placeholders anywhere in the file path or content.
- No complex expressions needed
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the SFTP Task product page. Step through them, or open any shot at full size.
Upload, download, loop, create
Send and receive multiple files.
Loop example
Get the file list, then loop through it.
From the product page: the Get File List operation returns an ADO.NET data table that a ForEach Loop can read.
-
File list columns
Columns and ordinals of the ADO.NET table.
0 => Path System.String 1 => Name System.String 2 => Size System.Int64 3 => LastWriteTime System.DateTime 4 => LastAccessTime System.DateTime 5 => CreationTime System.DateTime -
Enumerator
Enumerator
Foreach ADO EnumeratorPoint the ADO object source variable at the variable that holds the file list.
-
Two mapped columns, one row per file
Path Name /TestFolder/file1.json file1.json /TestFolder/output.json output.json Each loop iteration logs the path and name of one file.
Columns and output from the SFTP Task product page. See also Get list of files for looping.
Articles
Worked examples that use SFTP Task (FTP, FTPS).
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 SFTP Task (FTP, FTPS) on the canvas.
Which protocols are supported?
SFTP, FTP/SSL (FTPS) with explicit or implicit SSL/TLS, and classic FTP.
Can I authenticate with a private key?
Yes. Public / private key authentication is supported for SSH file transfer, as well as X509 client certificates and Kerberos / NTLM with single sign-on.
Can I transfer many files at once?
Yes. Use a wildcard pattern such as *.txt, or include / exclude patterns with regular expressions.
How do I loop through files on the server?
Get the file info list as an ADO.NET table and loop through it with a ForEach Loop (ADO Enumerator). See the loop example.
How does it protect credentials?
It can verify the SFTP server fingerprint and the SSL certificate thumbprint before sending credentials or any other data to the remote server.
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.
Where is the full property reference?
Open the SFTP Task help file.
What customers say
Start your free trial today
Install SSIS PowerPack and drag SFTP Task onto the Control Flow.
Create a connection, pick a storage action, and run, with no coding required.
- Control Flow Task in SSISSFTP Task (FTP, FTPS) 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.
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.