Dynamics AX Source

Overview

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

Setup

Use the options below to setup the component.

Options

DYNAMICS-AX

Select an existing Dynamics AX connection manager.

Related Topics: Dynamics AX Connection Manager

InputTables

Select one or more Dynamics AX tables to retrieve.

Statement

Specify select statement, based on selected input tables. Use %1 for the first table, %2 for the second table and so on.

How to modify input tables and statement dynamically at runtime?

The input tables 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 AX Source].[InputTables]. This is the property containing the input tables. Every table is separated with comma and line feed (,\n)
  • Scroll-down and find Expressions property. Setup expression to modify input tables dynamically.