The SugarCRM Source Component is an SSIS Data Flow Component for consuming data from the SugarCRM Service. The configuration parameters are provided in the standard data flow source component dialog.
Use the parameters below to set up the component.
Select an existing SugarCRM connection manager.
Related Topics: SugarCRM Connection Manager
Specify the number of rows to be retrieved as a batch.
Select the SugarCRM module.
Specify the WHERE clause. Optional.
Specify the ORDER BY clause. Optional.
Indicate whether or not to include deleted records in the result. This parameter has the options listed in the following table.
Indicate whether or not the module relationship fields should be included. This parameter has the options listed in the following table.
The source “module”, “query” and “order by” parameters are available in the data flow properties list. Follow these steps to set up an expression: