SSIS Salesforce Destination Connector (CRM)

SSIS Salesforce Destination Connector can be used to load large amount of data from any source to Salesforce.com without any programming. You can use simple drag and drop mapping to perform Bulk Insert/Upsert/Update and Delete operations.

Features

Load data into Salesforce.com from any source with drag and drop user interface
Perform multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert)
Option to use BULK API Mode (Millions of rows can be loaded with this mode)
Option to enable Multiple Threads for faster data loading
Highly secure data transfer using TLS1.2 Encryption mode
For Upsert operation capture outputs for Updated or Inserted Rows
Support for OAuth Access Token (Helpful for 2FA / MFA )
Support for executing assignment rule after Update/Insert operation for Case, Lead or Account
Provide Report Progress for every N rows, also Report row count summary at the end (i.e. Total Rows=nnn, Inserted = nnn, Updated=nnn, Deleted=nnn, Error=nnn, Time Took=nn:nn:nn.nnn)
Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Click here to see Salesforce related articles

SSIS Salesforce Connection Manager

SSIS Salesforce Connection Manager UI (Used with Salesforce Destination, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce Destination Connector – Upsert Example (Bulk Insert or Update)

SSIS Salesforce Destination Connector Settings (Bulk Insert, Upsert, Update, Delete)

SSIS Salesforce Destination Settings (Bulk Insert, Upsert, Update, Delete)

SSIS Salesforce Destination Connector Settings (Bulk Insert, Upsert, Update, Delete)

SSIS Salesforce Destination Connector Mappings

Articles / Tutorials

Click here to see all articles for [SSIS Salesforce Destination] category

SSIS PowerPack v2.9 released (Upsert Destination, Salesforce BULK API and more…)

What’s New In this release we focused on mainly providing high quality and super fast Upsert Destination (Bulk Update, Insert and Delete / Merge) for SQL Server. We also added Salesforce BULK API support for Salesforce Destination. Full Notes: https://zappysys.com/onlinehelp/ssis-powerpack/scr/release-notes.htm Version 2.9.0.10210 [Feb 08, 2019] New Features/Improvements NEW:Â Amazon S3 CSV File Source, FTP, Azure – […]

Load data in Salesforce using SSIS Insert, Upsert, Delete, Update

Introduction In this article we’re going to focus on load data in Salesforce using SSIS (Bulk Insert, Update, Delete and Upsert). If you like to know how to read from Salesforce then refer to previous post here. For Demo purpose we will use AdventuresWorks sample database as our source but you can use your own […]

References

Salesforce Query Language Reference (SOQL)

Articles/Posts

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install Oracle Drivers3.1 Sample Oracle ODBC Connection String3.2 Sample Oracle OLEDB Connection String4 Oracle CSV Export – Single table5 Oracle CSV Export – Multiple tables6 Oracle CSV Export – Multiple tables (using pattern)7 Oracle CSV Export – SQL Query8 Oracle CSV Export – Split […]

SQL Server Excel Export from Table or Query data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution3.1 Export Tables to CSV Using – ZappyShell Command Line Tools3.2 Export Tables to CSV Using – SSIS Export CSV File Task4 Download and Install ZappyShell Command Line Tools5 SQL Server Excel Export – Single table6 SQL Server Excel Export – Multiple tables7 SQL Server Excel Export – Multiple tables (using […]

SQL Server JSON Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution4 Export SQL Server data to JSON using SSIS PowerPack5 Export SQL Server data to JSON using ZappyShell Command line6 SQL Server JSON Export – Single table7 SQL Server JSON Export – Multiple tables8 SQL Server JSON Export – Multiple tables (using pattern)9 SQL Server JSON Export – SQL Query10 Using […]

SQL Server CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install SQL Server Drivers3.1 Sample ADO.net Connection String (No driver needed)3.2 Sample ODBC Connection String (SQL Native Client Driver)3.3 Sample OLEDB Connection String (SQL Native Client Driver)4 SQL Server CSV Export – Single table5 SQL Server CSV Export – Multiple tables6 SQL Server CSV […]

MySQL CSV Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 Download and Install MySQL ODBC Driver3 Download and Install ZappyShell Command Line Tools4 MySQL CSV Export – Single table5 MySQL CSV Export – Multiple tables6 MySQL CSV Export – Multiple tables (using pattern)7 MySQL CSV Export – SQL Query8 MySQL CSV Export – Split Files8.1 MySQL CSV Export – Split By Row Count8.2 […]

MySQL Excel Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL Excel Export – Single table7 MySQL Excel Export – Multiple tables8 MySQL Excel Export – Multiple tables (using pattern)9 MySQL Excel Export – SQL Query10 MySQL Excel Export – Split Files and Tabs10.1 MySQL Excel Export […]

MySQL JSON Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL JSON Export – Single table7 MySQL JSON Export – Multiple tables8 MySQL JSON Export – Multiple tables (using pattern)9 MySQL JSON Export – SQL Query10 Using Map File for nested MySQL JSON Export11 MySQL JSON Export […]