The Cloud Storage components from the SSIS Productivity Pack are SSIS components that facilitate integration with various cloud storage servers.

The SSIS Productivity Pack currently supports integration with 4 cloud storage solutions, Amazon S3, Azure Blob Storage, Dropbox, and Microsoft OneDrive. Each has a Connection Manager, Source, and Destination component to facilitate the integration. All four connection managers can also be used with the Premium Flat File Source, Premium Flat File Destination, Premium File Transfer Task, Premium Excel Source, and Premium Excel Destination components.

The following are the SSIS cloud storage components available within the SSIS Productivity Pack and their help manuals:

Amazon S3 Components

  • Amazon S3 Connection Manager
    • Facilitates connecting to AWS S3 from within SSIS.
  • Amazon S3 Source Component
    • An SSIS data flow component used to retrieve data from AWS S3. Includes the option to specify retrieval mode such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
  • Amazon S3 Destination Component
    • An SSIS data flow component used to facilitate writing data to AWS S3. This component supports CreateFolder, Delete, and Upload actions when writing to AWS S3.

Azure Blob Storage Components

  • Azure Blob Storage Connection Manager
    • Facilitates connection to Azure Blob Storage from within SSIS.
  • Azure Blob Storage Source Component
    • An SSIS data flow component used to retrieve data from Azure Blob Storage. Includes the option to specify retrieval mode such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
  • Azure Blob Storage Destination Component
    • An SSIS data flow component used to write data to Azure Blob Storage. This components allows developers to Create, Update, or Delete records when writing to Azure Blob Storage.

Dropbox Components

  • Dropbox Connection Manager
    • Used to establish the connection to Dropbox from within SSIS.
  • Dropbox Source Component
    • An SSIS data flow component that facilitates retrieving data from Dropbox with various item retrieval modes such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
  • Dropbox Destination Component
    • An SSIS data flow component that facilitates writing data to Dropbox. The component supports the options to create, delete, move or upsert objects to the cloud server.

Microsoft OneDrive Components

  • OneDrive Connection Manager
    • Used to establish the connection to Microsoft OneDrive from within SSIS.
  • OneDrive Source Component
    • An SSIS data flow component that facilitates retrieving data from Microsoft OneDrive with various item retrieval modes such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
  • OneDrive Destination Component
    • An SSIS data flow component that facilitates writing data to Microsoft OneDrive. The component supports the options to create, update, or delete objects to the cloud server.
  • OneDrive Token Manager
    • The Token Manager is used when development and deployment occur on different machines. It is a utility external to SSIS for adding, removing, importing or exporting OneDrive Tokens from machine to machine.

Youtube Video - Getting started with SSIS Productivity Pack - Microsoft OneDrive

Youtube Video - Getting started with SSIS Productivity Pack - Dropbox