Sage Destination


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

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

Looking for older releases? Check here.

Overview

Sage Destination Component is SSIS Data Flow Component for loading data into Sage SData entity. The configuration options are provided in the standard data flow destination component dialog. A separate input is setup for the main entity and each related composite entity.

Setup

Use the options below to setup the component.

Options

SAGE

Select an existing Sage connection manager.

Related Topics: Sage Connection Manager

Action

Select destination entity action. This property has the options listed in the following table.

Action Description
Create Create new record in the destination entity.
Update Update existing record in the destination entity. You have to specify entity key for the update to work.
Delete Delete existing record from the destination entity.

Note: After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination page metadata.

BatchSize

Specify the number of rows to be sent as a batch.

DestinationEntity

Specify the destination Sage SData entity where the data is loaded.

ErrorRowDisposition (Sage Destination Input)

Specify how to handle rows with errors.

Composite entity data

The composite entity input accepts sets of records, one set for each parent record. Each set of records must be separated with blank row (all NULLs). The parent entity will not finish processing its record, until all composite entity children have received blank row to indicate completion.