Sage Destination

Overview

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

Parameters

Configuration

Use the parameters below to configure the component.

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.

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.

Knowledge Base

What's New

1.6

New: Introduced component.

SSIS+ Components Suite

SSIS NoW

Excel Add-in for SAS

Overview

Parameters

Configuration

Knowledge Base

What's New

Newsletter

Contact Us

Follow Us

Support

SSIS+ Components Suite

SSIS NoW

Excel Add-in for SAS

Sage Destination

Overview

Parameters

Configuration

Knowledge Base

What's New

Related documentation