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 page to learn more about setting up the connection manager.
• Connection - Here you will select a connection manager that already exists or you may choose to create one here as well.
• SalesForce Object - The name of the SalesForce.com object that will be used to retrieve data from your SalesForce.com account. You will be able to 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.
• Batch Size - Determines the number of rows that will be retrieved during a single round trip to the SalesForce.com server.
• Include Deleted / Archived Records - Checking this option will return deleted and archived records. The "IsDeleted" column in the output will allow you to determine whether the row is "Deleted".
• Edit SalesForce Query - Checking this will make 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 will be filled with a query.
• Variable Parameters - Variables here can be dragged into the query window to edit or create new queries.
Salesforce Source and Destination - https://pragmaticworks.wistia.com/medias/qqol3f3ego
Export Data from Salesforce Source In Under 2 Minutes - https://pragmaticworks.wistia.com/medias/yxre6ee1jn