Read and write Google BigQuery data in SSIS with API Source + API Destination .

Use the Google BigQuery connector from Integration Hub to configure authentication, select endpoints, preview data, and map destination operations for writeback workflows.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Follow the landing-page flow: connector selection, auth setup, endpoint preview, then destination mapping.

Compatibility: SQL Server 2012-2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

Bi-Directional Connector Flow — Read with API Source and write with API Destination
Authentication in UI — Configure connector auth directly in connection manager
Endpoint Preview Workflow — Validate API calls before package execution
Retry-Aware Runtime — Use retry settings for resilient API processing
Mapped Writeback Actions — Apply insert, update, delete, and lookup patterns via mappings

📸 Visual Overview & Setup

1. Drag API Source to Data Flow 🔍 View Full Size	2. Drag API Destination to Data Flow 🔍 View Full Size	3. Pick or Search Connector 🔍 View Full Size
4. Map the Columns 🔍 View Full Size	5. Select Endpoint and Preview data 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

Connector Workflow

Use API Source for extraction and API Destination for writeback in one package
Configure connector endpoints and parameters using the SSIS UI
Preview endpoint output before finalizing mappings

Authentication & Runtime Controls

Configure connector authentication in connection manager
Use retry mode and status code settings for resilient runs
Run in SQL Server and Azure-SSIS Integration Runtime environments

💡 Common Use Cases

Common scenarios based on the landing-page flow:

Data Export: Extract API data with API Source for downstream ETL.
Writeback Integration: Push transformed rows to API endpoints via API Destination.
Validation Before Execute: Preview endpoint output and adjust mappings.
Operational Stability: Apply retry settings for transient API failures.

🎯 Summary

SSIS Google BigQuery Connector follows a connector-driven setup for read/write integration in SSIS.
Configure auth, preview endpoints, map fields, and execute resilient API pipelines without custom API coding.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Purpose-built for high-performance ETL and integration scenarios.
Expert Technical Support: Direct access to engineers via email and remote screen-share sessions.
Proven Enterprise Scale: Trusted by 3000+ teams across 90+ countries.

SSIS PowerPack

Includes SSIS Google BigQuery Connector