FTP, FTPS, & SFTP in SSIS

  • Connect to FTP, FTPS, and SFTP servers to manage and manipulate files with ease within SSIS.
  • A unified framework to work with cloud or local files in an identical way by extracting and loading data from/to FTP/FTPS/SFTP servers without the need to save the files locally.
  • Transparently work directly with data stored within flat files on the server or with file system and folder data.
  • Easily transfer files and perform basic file and directory manipulations.
  • Part of SSIS Productivity Pack, a collection of over 80 SSIS add-on components to enable greater development productivity.

SSIS SFTP Task
Powered by Premium File Transfer Task

  • Easily transfer files and perform basic file and directory manipulations, such as Send Files, Delete Files, Create Files, or Remove Directory from SFTP, FTPS, or FTP servers using Premium File Transfer Task.
SSIS SFTP connection manager
SSIS premium file system source
SSIS premium flat file destination
SSIS premium file transfer task

Experience SSIS SFTP & FTPS with SSIS Productivity Pack

  Download My Free Copy

ssis ftps connector  SSIS FTPS Connection Manager

  • Facilitates connection to an FTP or FTPS server.
  • Supports TLS encryption through Explicit or Implicit mode.
  • Advanced settings to help with special FTPS server configurations and behaviours.

ssis sftp connector  SSIS SFTP Connection Manager

  • Facilitates connection to an SFTP server.
  • Supports authentication through Password or Key.
  • Advanced settings to help with special SFTP server configurations and behaviours.

These two connection managers can be used to perform a large variety of procedures in SSIS including file transfer, and data retrieval. These connection managers in combination with other components within SSIS Productivity Pack offer developers greater potentials when working with SFTP, FTPS, & FTP servers within SSIS.

Use SFTP & FTPS Connection Managers within the following components, all found within SSIS Productivity Pack:

  • Premium Flat File Source,
  • Premium Flat File Destination,
  • Premium File Transfer Task,
  • Premium Excel Source,
  • Premium Excel Destination,
  • Premium File System Source,
  • Premium File System Destination