SSIS Salesforce Destination Connector (CRM Destination)

⚡ Key Benefits

• Bulk Write Operations — Perform Bulk Insert, Update, Delete, and Upsert to Salesforce from any SSIS source
• BULK API Mode — Load millions of rows efficiently using Salesforce BULK API processing
• Multi-Threaded Throughput — Enable parallel threads for faster high-volume data loading
• OAuth + TLS Security — Secure transfer with TLS 1.2 and OAuth access token support (2FA/MFA friendly)
• Operational Visibility — Report progress every N rows and final row-count summary (inserted/updated/deleted/errors)

📸 Visual Overview & Setup

1. Drag & Drop into Data Flow 🔍 View Full Size	2. Configure Salesforce Connection Manager 🔍 View Full Size	3. Upsert Example (Bulk Insert / Update) 🔍 View Full Size
4. Destination Settings (Insert/Upsert/Update/Delete) 🔍 View Full Size	5. Column Mappings 🔍 View Full Size	6. Full Settings UI 🔍 View Full Size

🔧 Key Features

Write Operations

• Perform Bulk Insert, Update, Delete, and Upsert into Salesforce objects
• BULK API mode for high-volume loads (millions of rows)
• Capture Upsert outputs for inserted vs updated rows

Performance & Reliability

• Multi-threaded loading for faster throughput
• Progress reporting every N rows plus final summary stats
• Error row routing and operational visibility for large data movements

Security & Automation

• TLS 1.2 encrypted transfer
• OAuth access token support for MFA/2FA scenarios
• Execute assignment rules after insert/update for Case, Lead, and Account

💡 Common Use Cases

Common real-world scenarios for loading Salesforce from SSIS:

• CRM Data Sync: Upsert account/contact changes from SQL Server to Salesforce on a schedule.
• Bulk Migration: Load historical records into Salesforce using BULK API and threaded execution.
• Master Data Alignment: Keep target Salesforce objects synchronized with source-of-truth systems.
• Operational Auditing: Route inserted/updated/error rows to separate outputs for QA and reconciliation.

🎯 Summary

Replace custom Salesforce loading scripts with a drag-and-drop destination optimized for enterprise-scale data movement.
Run secure, high-speed bulk insert/update/delete/upsert operations with OAuth, BULK API, progress tracking, and row-level outputs — all inside native SSIS 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 Destination Read reviews on Capterra →