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 records, 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 records and the children records is used to match children to parents. As each parent record is processed from one input, the associated children records 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 record 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.
For additional information about modelling of composite records in SSIS+, please refer to this article.
- 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.
- New: Introduced component.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.