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 2 cloud storage solutions, Dropbox and Microsoft OneDrive. Each has a Connection Manager, Source, and Destination component to facilitate the integration. Both connection managers can also be used with the Premium Flat File Source, Premium Flat File Destination, and Premium File Transfer Task components.

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

  • 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.
  • 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