Dynamics GP Source

Overview

Dynamics GP Source Component is SSIS Data Flow Component for consuming data from Dynamics GP Service. The configuration parameters are provided in the standard data flow source component dialog. A separate output is setup for the main object and each related composite object.

Specify criteria XML. The criteria should be the same XML format used to serialize Dynamics GP restrictions. For example to retrieve all employees from the sales department, use the following criteria:

The composite object output contains not only properties from the composite object, but also the parent objects. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all NULLs).

What's New

1.6 SR-3

Fixed: Component returned only first 1000 records (Thank you, Patricia).