SugarCRM Destination

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

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.