Dynamics GP Destination

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

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

All Downloads ----- Questions?

Overview

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


Setup

Use the options below to setup the component.

Options

DYNAMICS-GP

Select an existing Dynamics GP connection manager.

Related Topics: Dynamics GP Connection Manager

Action

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

Action Description
Create Create new record in the destination Dynamics GP object.
Update Update existing record in the destination Dynamics GP object. You have to specify object identifier for the update to work.
Delete Delete existing record from the destination Dynamics GP object.
Void Void existing record from the destination Dynamics GP object.

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

DestinationObject

Specify the destination Dynamics GP object where the data is loaded.

ErrorRowDisposition (Main object Input)

Specify how to handle rows with errors.

Composite object data

The composite object 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 object will not finish processing its record, until all composite object children have received blank row to indicate completion.