Dynamics GP Destination
Dynamics GP Destination Component is SSIS Data Flow Component for loading data into a Dynamics GP object. The configuration parameters are provided in the standard data flow destination component dialog. Composite Objects are supported.
Use the parameters below to configure the component.
Select an existing Dynamics GP connection manager.
Related Topics: Dynamics GP Connection Manager
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.After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination page metadata.
Specify the destination Dynamics GP object where the data is loaded.
Specify how to handle rows with errors.
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. You can use Query transform to prepare child data with the proper blank rows.
- Fixed: Component failed with error "Invalid cast from '...' to 'CozyRoc.Dynamics.Gp.Service.Amount'" when processing GL Transaction object (Thank you, John).
- Fixed: Component failed to report errors in 'Error Output' (Thank you, Adriana).
- Fixed: Numerous fixes and enhancements (Thank you, Patricia).
- New: Redesigned for better support of composite data.
Ready to give it a try?
COZYROC SSIS+ Component Suite is free for testing in your development environment.