OpenAir Destination

Overview

OpenAir Destination Component is SSIS Data Flow Component for loading data into OpenAir type. The configuration parameters are provided in the standard Data Flow Component dialogs.

Parameters

Configuration

Use the parameters below to configure the component.

OPENAIR

Select an existing OpenAir connection manager.

Related Topics: OpenAir Connection Manager

Action

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

Action	Description
Create	Create new record in the destination type.
Modify	Modify existing record in the destination type. You have to specify id field for the update to work.
Delete	Delete existing record from the destination type.
Upsert	Update and insert record in the destination type. You have to specify externalid for action to work.

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

AssociationCustom
1.6 SR-3

Specify type association to initialize custom fields for it.
DestinationType

Specify the destination OpenAir type where the data is loaded.
BatchSize

Specify the number of rows to be sent as a batch.
ErrorRowDisposition (OpenAir Destination Input)

Specify how to handle rows with errors.
Id (OpenAir Destination Error Output)

Contains the unique identifier of the added, updated or deleted record.

Knowledge Base

What's New

1.6 SR-3

New: A new parameter AssociationCustom.

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

OpenAir Destination

Overview

Parameters

Configuration

Knowledge Base

What's New

Related documentation