Dynamics AX Destination

Overview

Dynamics AX Destination Component is SSIS Data Flow Component for loading data into Microsoft Dynamics AX table. The configuration options are provided in the standard data flow destination 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

Action

Select destination table action. This property has the options listed in the following table.

Action	Description
Create	Create new record in the destination table.
Update	Update existing record in the destination table. You have to specify the appropriate table record identifier for the update to work.
Delete	Delete existing record from the destination table. You have to specify the appropriate table record identifier for the delete to work.

Note: After action change, you have to use Refresh command in the 'Column Mappings' tab to reload destination table metadata.

DestinationTable

Specify the destination Dynamics AX table where the data is loaded.

ErrorRowDisposition (Dynamics AX Destination Input)

Specify how to handle rows with errors.

How to modify destination table dynamically at runtime?

The destination table is 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 Destination].[DestinationTable]. This is the property containing the destination table.
• Scroll-down and find Expressions property. Setup expression to modify the destination table dynamically.