Overview
The SugarCRM Destination Component is an SSIS Data Flow Component for loading data into a SugarCRM module. The configuration parameters are provided in the standard data flow destination component dialog.
Setup
Use the parameters below to set up the component.
Parameters
- SUGARCRM
-
Select an existing SugarCRM connection manager.
Related Topics: SugarCRM Connection Manager
- DestinationModule
-
Specify the destination SugarCRM module where the data is loaded.
- BatchSize
-
Specify the number of rows to be sent as a batch.
- ErrorRowDisposition (SugarCRM Destination Input)
-
Specify how to handle rows with errors.
- Id (SugarCRM Destination Error Output)
-
Contains the unique identifier of the updated record.
How to modify a destination module dynamically at runtime
The destination module is available in the data flow properties list. Follow these steps to set up an expression:
- Right-click on the data flow canvas and select the Properties menu.
- Scroll down and find the property named like [SugarCRM Destination].[DestinationModule]. This is the property containing the destination module.
- Scroll down and find the Expressions property. Set up an expression to modify the destination module dynamically.
How to update an existing module record
To update an existing module record follow these steps:
- Map the columns you want updated.
- Map the module Id column to the updated record identifier.
How to delete a module record
The component cannot delete module records. However you can mark specific records as deleted. Follow these steps:
- Map the module Id column to the deleted record identifier.
- Set the module deleted column to True.
