Cloud Storage Components

Cloud Storage Components

The Cloud Storage SSIS Components streamline data integration with cloud storage services, offering sophisticated features and flexibility. For each cloud storage service, we provide a Connection Manager, a Source component that can be used to retrieve files and documents, and a Destination component used to write data or documents.

Additionally, these cloud storage connectors can also be used with the following additional storage/file-related components:

• EDI Source
• EDI Destination
• Premium Data File Source
• Premium Data File Destination
• Premium Flat File Source
• Premium Flat File Destination
• Premium File Properties Task
• Premium File Transfer Task
• Premium Excel Source
• Premium Excel Destination

---

The following are the Cloud Storage Components available with 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 folders 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 folders 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

• Google Drive Connection Manager
  • Used to establish the connection to Google Drive from within SSIS.
• Google Drive Source Component
  • An SSIS data flow pipeline component that can be used to read/retrieve data from Google Drive.
• Google Drive Destination Component
  • An SSIS data flow pipeline component that can be used to write data to Google Drive.

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