Used with SalesForce.com Source and SalesForce.com Destination.
Login Information Tab
User Name (email address)
This is your log in email address for SalesForce.com.
Password and Security Token
If you do not have your security token you must request it from SalesForce.com. You can do this by logging into your SalesForce account on their site, selecting the Setup link, and then selecting to Reset your security token. Important: Enter the password and security token without a delimiter, in the following format:
Seconds before the connection times out trying to connect.
Server URL (optional)
If you are using a SalesForce.com sandbox account the Server URL text box needs to be changed to point to a sandbox web service URL.
Reuse same connection across all tasks
This option allows you to use the same connection across any SalesForce task that is part of your package, that uses this connection manager.
Number of retry attempts
Identifies the number of attempts to reconnect to Salesforce before the component fails. This option is useful when pulling large datasets and executions fail due to timing out.
Do Not Retry - The component does not attempt to reconnect. Retry For Any Errors - The component attempts to reconnect for any error. Retry for Http Status codes - The component attempts to reconnect for Http Status codes that you enter in the Response status codes to retry separated by field. Retry for Exception Message - The component attempts to reconnect for exception messages that you enter in the Exception messages to retry separated by field.
Number of Retries
Set the number of attempts to reconnect to Salesforce before the component fails. This option is useful when pulling large datasets and executions fail due to timing out. Note: This option becomes available when you select a Retry Mode other than Do Not Retry.
Retry Delay (in seconds)
Set the time in seconds that the component waits before trying to connect to Salesforce. Note: This option becomes available when you select a Retry Mode other than Do Not Retry.
Response status codes to retry separated by
Enter the response status codes that if encountered, the component tries to reconnect. Note: Enter multiple Response status codes separated by a | (bar). This option becomes available when you select Retry for Http Status codes.
Exception messages to retry separated by
Enter the exception messages that if encountered, the component tries to reconnect. Note: Enter multiple Exception messages seperated by a | (bar). This option becomes available when you select Retry for Exception Messages.
Proxy Information Tab
Note: Auth Scheme is only available on machines that are running SQL 2008 only.
If you wish to make your connection through a proxy you first select Use Proxy, andthen fill out the appropriate information below in the Proxy Information pane.
The SalesForce.com source is used to retrieve data from SalesForce.com objects within an SSIS package. The data is retrieved using a SQL statement built by the SalesForce.com source. See the SalesForce.com Connection Manager to learn more about setting up the connection manager.
Note: SalesForce Source 2019.1.1 and above support nested queries.
Here you select a connection manager that already exists or you may choose to create one.
The name of the SalesForce.com object that is used to retrieve data from your SalesForce.com account. Choose your object from the drop down list after connecting to SalesForce.com. Once your object is selected, a query is created in the text box below.
Determines the number of rows that are retrieved during a single round trip to the SalesForce.com server.
Include Deleted / Archived Records
Selecting this option returns deleted and archived records. The IsDeleted column in the output allows you to determine whether the row is deleted.
Normal - Uses normal processing which can use up to 200 batch size. Normal mode is a SOAP request.
BulkQuery - Uses bulk processing that can achieve up to 10,000 batch size. BulkQuery mode is webrequest with a file stream.
Output Date As:
Using BulkQuery mode, you can choose between the Local Time Zone or UTC Time Zone options.
Using the BulkQuery mode, you can choose between parallel (based on the batch size) and serial (one record at a time) modes.
Status Check Interval (seconds)
The amount of time in seconds before a status check occurs. Note: The Status Check Interval is two seconds by default.
Edit SalesForce Query
Selecting this makes the auto filled query editable. Note: : Variable replacements can be used within queries. The syntax used is <User::MyVariableName>. For variable replacements that require the elimination of tics (''), use the syntax <User::MyVariableName, false>. For example: SELECT <User::OpportunityId, false> FROM Opportunity
SalesForce Query Window
Once your object is selected, this window fills with a query.
Variables here can be dragged into the query window to edit or create new queries.
Export Data from Salesforce Source In Under 2 Minutes
The SalesForce.com Destination is used to send data to a SalesForce.com object. See the SalesForce.com Connection Manager to learn more about setting up the connection manager.
Here you select an existing SalesForce.com connection, or create a new one.
Once selecting the connection, you then select and object where the data is inserted within your SalesForce.com account.
Insert - Use this option to insert data into the SalesForce object.
Upsert - Use this option to insert data into the SalesForce object if the data does not exist or update the data if it already exists. Upsert requires that an external ID be added to your SalesForce object in your SalesForce.com account.
Update - Update your data in the SalesForce object based on the ID column from the SalesForce object. This means that the ID from the SalesForce object needs to exist in the local source data. To the ID column data the TF Sales source Adapter needs to be used to retrieve the data or the ID needs to be retrieved and updated using the output from the SalesForce Destination.
Delete - Delete is used to delete data from the SalesForce object. Again, the ID column of the SalesForce object needs to be used to delete the data.
Upsert External ID
If you selected the Upsert action you must select your External ID here.
You can configure a custom batch size (200 or less).
Select an assignment rule created for their object(s). Rules can be ignored by selecting [No Assignment Rule].
Normal - Uses normal processing which can use up to 200 batch size.
Bulk - Uses bulk processing that can achieve up to 10,000 batch size. Bulk mode uses more network traffic but less IO because no compression occurs.
BulkZip - Also uses bulk processing but compresses the bulk CSV file before sending. BulkZip uses more IO for compression but less network traffic.
Using bulk processing mode, you can choose between parallel (based on the batch size) and serial (one record at a time) modes.
Map SalesForce Destination Columns
Once you have an object selected, the columns here will be filled. Any column names that match are automatically mapped. To map more columns, select on the Input column that you wish to be mapped to the destination column.
How to handle errors
There are three options to handle errors:
Fail Component - The component fails upon the first data error that is thrown.
Redirect row to error output - The rows of data that failed are sent to the error output which then can be used to handle the data errors.
Ignore Failure - The failures are ignored but reported in the Execution Results log.
Refresh Salesforce Columns
Selecting this button allows the component to refresh the metadata and update any changes made in Salesforce after the destination was opened.
Wait For Bulk Results
This selection can be used along with the bulk processing mode. When selected, it sends a batch of rows to a job and waits for the results of the operation (insert, update, upsert, delete) and then outputs the results to the success output with the ID's generated by Salesforce when updated or created. If this option is not selected, the component does not wait for the results and processes the execution as quickly as possible, and the Salesforce ID is not properly returned.
Use Legacy Output Mode
In legacy versions of Task Factory, you could update the unique ID's created by Salesforce.com by connecting a destination component to the Salesforce Destination's error output. This legacy output also returned errors (when error handling was enabled) which could be confusing when sifting through multiple updates mixed with errors. The current version now defaults with the option turned off thus directing the unique ID to the success output. This change allows you to separate the data returned from Salesforce.com from the error output.
Configuring the Salesforce Destination using Expressions
Users who wish to use expressions to configure different properties of the Salesforce Destination should follow these steps:
Return to the package's control flow.
Right-click the Data Flow that contains the Salesforce Destination and select properties.
Navigate to the Expressions property and select the ellipsis.
Select the property in the dropdown menu to be configured.