Dynamics GP Destination

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

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

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

Overview

Dynamics GP Destination Component is SSIS Data Flow Component for loading data into a Dynamics GP object. The configuration options are provided in the standard data flow destination component dialog. Composite Objects are supported.


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

When working with composite data, one input must be set up which contains the main objects (parents) and a separate input must be set up which contains the related composite objects (children). The order of the parent objects and the children objects is used to match children to parents. As each parent object is processed from one input, the associated children objects are processed from the other input.

To mark the end of children associated with a parent, a blank row (all NULLs) much be present in the input. The processing of a parent object is only completed when a blank row is encountered at the end of the children for that parent. The final record in the children input must be a blank row in order to complete the processing.