You can use the following reusable script with the JavaScript component to retrieve records that were deleted from Salesforce between specified dates: https://www.cozyroc.com/ssis/script-salesforce-get-deleted-source To retrieve records that have ...
The Salesforce SOQL Statement property is available in the data flow properties list to be set dynamically at run time. Note: The process for setting the BatchSize, Object and ObjectFilter properties for Salesforce are the same as for the Statement ...
The following concern applies to previous releases (before 1.9). Currently, all columns from the SOQL are automatically created, but in some cases, the data type of the column might not be retrieved from the results and a WSTR 250 would be assumed. ...
The Object, ObjectFilter or Statement parameters are available for setup in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select Properties from the menu. Scroll-down and find a ...