Devart Salesforce Source is a data flow component that makes data from a Salesforce data source available to other data flow components. It supports SQL SELECT statements. Besides, you can use SSIS Package system variables and user-defined variables in the SELECT statement.

Note:
According to the Salesforce naming conventions, Salesforce custom object and field names are supplemented with a suffix consisting of two underscores followed by a lowercase 'c' character, e.g. 'AccountCreatedBy__c'. While the Salesforce user interface displayes these suffixes, the Devart Salesforce Source Editor does not display them.

Furthermore, Devart Salesforce Source component supports the Include Deleted Records option, setting it to true will return deleted records.