Dynamics CRM Source

Overview

Dynamics CRM Source Component is SSIS Data Flow Component for consuming data from Dynamics CRM Service. The configuration options are provided in the standard data flow source component dialog.

Setup

Use the options below to setup the component.

Options

DYNAMICS-CRM

Select an existing Dynamics CRM connection manager.

Related Topics: Dynamics CRM Connection Manager

BatchSize

Specify the number of rows to be retrieved as a batch. The maximum is 500.

InputType

Specify input type. This property has the options listed in the following table.

Value Description
Entity Input type is Dynamics CRM entity. Selecting this value displays the dynamic option Entity.
FetchXML Input type is FetchXML query. Selecting this value display the dynamic option FetchXML.

Note: After input change, you have to use Refresh command in the 'Column Mappings' tab to reload source entity metadata.

Entity

Select Dynamics CRM data entity.

FetchXML

Specify FetchXML statement. Select to design your query in the standard Advanced Find dialog.
Note: Advanced Find is not available in CRM 3.0

How to modify source dynamically at runtime?

The source entity or query 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 CRM Source].[FetchXML]. This is the property containing the query.
  • Scroll-down and find Expressions property. Setup expression to modify the query dynamically.