Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Advanced Lookup Transform Icon

Buy Now Free Trial Download Compare Editions

Task Factory SalesForce.com Destination

With this component you will be able to very easily add data from your system into your salesforce.com account with very little configuration.

Feature Highlights

  • The easy to use UI allows mapping of columns from your data to columns in the salesforce.com
  • *Must have an enterprise salesforce.com account to use this task. This is a salesforce.com requirement.
SalesForce.com Destination

Salesforce.com Destination - Step 1

The Salesforce.com Destination is used to send data to a salesforce.com object


The Salesforce.com Destination is used to send data to a salesforce.com object


Salesforce.com Destination - Step 2
The first step in configuring the SalesForce.com destination is to select or create a connection. If a connection has not been created select "<Create New SalesForce.com Connection...>".

Selecting "<Create New SalesForce.com Connection...>" will show the SalesForce.com connection manager window.

The first step in configuring the SalesForce.com destination is to select or create a connection. If a connection has not been created select "<Create New SalesForce.com Connection...>".

Selecting "<Create New SalesForce.com Connection...>" will show the SalesForce.com connection manager window.

Salesforce.com Destination - Step 3

The SalesForce.com login information is the SalesForce.com email address and the password + security token. If you don't have your security token you must request it from SalesForce.com by clicking the "Setup" link at the top of the SalesForce.com website after you have logged into your account. Then click on the "Reset your security token" under the "My Personal Information".

The SalesForce.com login information is the SalesForce.com email address and the password + security token. If you don't have your security token you must request it from SalesForce.com by clicking the "Setup" link at the top of the SalesForce.com website after you have logged into your account. Then click on the "Reset your security token" under the "My Personal Information".

Salesforce.com Destination - Step 4

If you're using a salesforce.com sandbox account the Server URL (optional) textbox in the Advanced tab needs to be changed to point to as and box webservice url. Choose  from one of the url's below:

https://test.salesforce.com/services/Soap/u/17.0

https://test.salesforce.com/services/Soap/u/20.0

https://test.salesforce.com/services/Soap/u/24.0

If you're using a salesforce.com sandbox account the Server URL (optional) textbox in the Advanced tab needs to be changed to point to as and box webservice url. Choose  from one of the url's below:

https://test.salesforce.com/services/Soap/u/17.0

https://test.salesforce.com/services/Soap/u/20.0

https://test.salesforce.com/services/Soap/u/24.0

Salesforce.com Destination - Step 5
After a connection has been selected or created an object will need to be selected. The selected object is where the data will be inserted within your salesforce.com account.

After a connection has been selected or created an object will need to be selected. The selected object is where the data will be inserted within your salesforce.com account.

Salesforce.com Destination - Step 6

By default, the "Action" will be"Insert". The action can be changed by clicking the"Action" drop down list and choosing on the four options.

Insert - Use thisoption to Insert data into the SalesForce object

Upsert - Use thisoption to Insert data into the SalesForce object if the data doesn't exist(based on External ID) or Update the data if it already exists (based onExterna ID field). Upsert requires that an External ID be added to yourSalesForce object in your SalesForce.com account. The External ID needs to beselected in the UI and that the ExternalID column in your SalesForce object bemapped in the mappings.

Update – Thisoption will only update rows that already exist in the destination object.

Delete – Use thisoption to delete rows from the destination object.

The External ID column is filled with data fromyour local system that contains a unique identifier (usually a primary key froma table). The External ID is used to check whether the row of data exists in the SalesForce object.


By default, the "Action" will be"Insert". The action can be changed by clicking the"Action" drop down list and choosing on the four options.

Insert - Use thisoption to Insert data into the SalesForce object

Upsert - Use thisoption to Insert data into the SalesForce object if the data doesn't exist(based on External ID) or Update the data if it already exists (based onExterna ID field). Upsert requires that an External ID be added to yourSalesForce object in your SalesForce.com account. The External ID needs to beselected in the UI and that the ExternalID column in your SalesForce object bemapped in the mappings.

Update – Thisoption will only update rows that already exist in the destination object.

Delete – Use thisoption to delete rows from the destination object.

The External ID column is filled with data fromyour local system that contains a unique identifier (usually a primary key froma table). The External ID is used to check whether the row of data exists in the SalesForce object.


Salesforce.com Destination - Step 7

The default batch size is set to 200 rows. This is themaximum number of rows allowed when the Process Mode is set to Normal. Thereare two additional Process Mode settings.

Bulk- Allows fora maximum of 10,000 rows to be sent to the Salesforce object.

BulkZip- Compressthe data in Bulk Mode to a zip file to speed up the process.


The default batch size is set to 200 rows. This is themaximum number of rows allowed when the Process Mode is set to Normal. Thereare two additional Process Mode settings.

Bulk- Allows fora maximum of 10,000 rows to be sent to the Salesforce object.

BulkZip- Compressthe data in Bulk Mode to a zip file to speed up the process.


Salesforce.com Destination - Step 8

After an object is selected, the Map SalesForce Destination Columns grid will be filled. Any column names that match will be automatically mapped.


After an object is selected, the Map SalesForce Destination Columns grid will be filled. Any column names that match will be automatically mapped.


View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works