SSIS Salesforce API Task (Call REST/SOAP API)

Call Salesforce REST and SOAP APIs from SSIS using a no-code task.

Configure authenticated requests, test request/response, extract JSON/XML values, and persist outputs to variables or files for orchestration workflows.
Part of ZappySys SSIS PowerPack.

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Use test mode plus response filters to validate endpoint behavior before production runs.

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

⚡ Key Benefits

Unified API Execution — Call Salesforce REST and SOAP endpoints in one task
Testable Request Workflow — Inspect request/response cycles during design
Response Extraction Controls — Parse JSONPath/XPath values for downstream logic
Flexible Output Storage — Save response content to SSIS variables or files
Validation & Reliability — Apply response code/content rules to harden automation

📸 Visual Overview & Setup

1. Drag Salesforce API Task 🔍 View Full Size	2. Salesforce Connection Manager 🔍 View Full Size	3. Call REST API (JSON) 🔍 View Full Size
4. Call SOAP/XML API 🔍 View Full Size	5. Response Save Options 🔍 View Full Size	6. Advanced Task Settings 🔍 View Full Size

🔧 Key Features

Call Salesforce REST and SOAP APIs from SSIS control flow
Dynamic request/header templating with variable placeholders
JSONPath/XPath response extraction support
Response validation rules and status-code checks
Save response payloads to variable or file targets

💡 Common Use Cases

Operational API Automation: Trigger Salesforce actions from SSIS package orchestration.
Metadata/Utility Calls: Execute REST/SOAP requests beyond standard source/destination adapters.
Response-Driven Workflow: Branch SSIS logic based on parsed API outputs.
File/Variable Persistence: Store API responses for auditing or downstream processing.

🎯 Summary

SSIS Salesforce API Task gives teams flexible, low-code control to invoke Salesforce endpoints and operationalize responses inside ETL pipelines. It simplifies request testing, response handling, and reliability checks for enterprise workflows.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Purpose-built for high-performance ETL and complex 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, including Fortune 500.

SSIS PowerPack

Includes SSIS Salesforce API Task

Read reviews on Capterra →

Start Automating Workflows with SSIS PowerPack

Includes connectors for APIs, databases & cloud apps. Build robust ETL workflows without custom scripting.

Download SSIS PowerPack (Free Trial)

Full functionality is FREE for development within Visual Studio