Dynamics GP Source

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

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

All Downloads ----- Questions?

Overview

Dynamics GP Source Component is SSIS Data Flow Component for consuming data from Dynamics GP Service. The configuration options are provided in the standard data flow source component dialog. A separate output 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

Object

Select Dynamics GP object.

ObjectCriteriaXML

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:

<EmployeeCriteria>
	<DepartmentId xmlns="http://schemas.microsoft.com/dynamics/gp/2006/01">
		<EqualValue>SALE</EqualValue>
	</DepartmentId>
</EmployeeCriteria>
SummaryOnly

Specify whether object summary or complete object is returned. This property has the options listed in the following table.

Value Description
True Only object summary properties are retrieved. Default. Using this option will improve reading performance significantly.
False All object properties are retrieved.

Composite object data

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).

How to modify source criteria dynamically at runtime?

The source object and criteria are available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [Dynamics GP Source].[ObjectCriteriaXML]. This is the property containing the criteria.
  • Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.