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.
