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

SSIS Productivity Pack supports integration with a number of cloud storage solutions, including:

For each cloud storage service, we provide a Connection Manager to facilitate the connection, a Source component that can be used to retrieve files and documents, and a Destination component that can be used to write data or documents. In addition, our cloud storage connections can also be used with the following additional storage/file related 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 folderss 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 folderss 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 component allows developers to Create, Update, or Delete records when writing to Azure Blob Storage.

Azure Data Lake Storage Components

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

Azure Files Components

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

Box Components

  • Box Connection Manager
    • Facilitates connection to Box from within SSIS
  • Box Source Component
    • An SSIS data flow component used to retrieve data from Box. Includes the option to specify retrieval mode such as retrieving files and folders or only files or choosing whether sub-items should be retrieved as well.
  • Box Destination Component
    • An SSIS data flow component used to write data to Box. This component allows developers to Create, Update, or Delete records when writing to Box.
  • Box 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 Box Tokens from machine to machine.

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

Google Cloud Storage Components

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

Google Drive Components

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 folders 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. This component supports the option 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.

Video Resources

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

Youtube Video - Getting started with SSIS Productivity Pack - Dropbox