Google Services Components

Google Services SSIS Components facilitate data integration with a variety of Google services, such as Google Maps and AlloyDB. The following are the Google Services Components available within the SSIS Productivity Pack, and their help manuals:

Google Ads Components

Google AlloyDB Components

Google Analytics Components

Google BigQuery Components

Google Calendar Components

Google Classroom Components

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 folder 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 Forms Components

Google Maps Components

Google People Components

Google Search Console Components

Google Sheets Components

  • Google Sheets Connection Manager
    • Facilitates connection to a Google Sheets document through a Google account and the Google Sheets REST API.
  • Google Sheets Source Component
    • An SSIS data flow component which facilitates retrieving data from a Google Sheet.
  • Google Sheets Destination Component
    • An SSIS data flow component which is used to facilitate writing data to a Google Sheet. Developers will be able to specify if they would like to Append, Update, Clear, CopyTo, Create, or Batch Update when writing to Google Sheets.

Google Tag Manager Components

YouTube Analytics Components

Shared Utilities

  • Google Services Token Manager
    • The Google Services 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 Tokens from machine to machine.

Video Resources

Youtube Video - Getting started with SSIS Productivity Pack - Google Sheets

Youtube Video - Getting started with SSIS Productivity Pack - Google BigQuery

Youtube Video - Getting started with SSIS Productivity Pack - Google Analytics

Youtube Video - Getting started with SSIS Productivity Pack - Google AdWords