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 ...
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...
CozyRoc Rest Source Component allow you to Read data from REST API. The developer can quickly extract response data from the desired endpoint using HTTP Method (GET, POST) and Output into columns data in preview tab. In this article, we will walk ...
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...