Premium File Pack components offer sophisticated robust components to work with files easily within SSIS

There are currently two connection managers, four data flow components and one task component found under the Premium File Pack:

Youtube Video - Getting started with SSIS Productivity Pack - Premium File Pack

  • FTPS Connection Manager
    • Enables connecting to an FTPS server within SSIS.
  • SFTP Connection Manager
    • Enables connecting to an SFTP server within SSIS.
  • Premium File System Source
    • Read/retrieve data from a file system. Supports the following connection managers: FTPS, SFTP, and local.
  • Premium File System Destination
    • Write data to a file system. Supports the following connection managers: FTPS, SFTP, and local.
  • Premium Flat File Source
    • Read/download data from a file. Supports the following connection managers: FTPS, SFTP, local, SharePoint, OneDrive, Dropbox, Amazon S3, and Azure Blob Storage.
  • Premium Flat File Destination
    • Write data to a file. Supports the following connection managers: FTPS, SFTP, local, SharePoint, OneDrive, Dropbox, Amazon S3, and Azure Blob Storage.
  • Premium File Transfer Task
    • Allows you to transfer and perform basic file system tasks within SSIS. Supports the following connection managers: FTPS, SFTP, local, SharePoint, OneDrive, Dropbox, Amazon S3, and Azure Blob Storage.