Overview
Data flow source to retrieve Salesforce object deleted record identifiers.
Setup
The script has the following parameters:
- Connection - selects Salesforce connection.
- SalesforceObject - selects Salesforce object.
- IsStartDateVariable - indicates whether the start date is stored in a variable.
- StartDate - specifies start date.
- StartDateVariable - selects variable containing start date.
- IsEndDateVariable - indicates whether the end date is stored in a variable.
- EndDate - specifies end date.
- EndDateVariable - selects variable containing end date.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Salesforce_Get_Deleted_Source.jsKnowledge Base
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.