Tags: 
1.5, Component, Destination, Dynamics AX

Overview

The Dynamics AX Destination Component is an SSIS Data Flow Component for loading data into a Microsoft Dynamics AX table. The configuration parameters are provided in the standard data flow destination component dialog.


Demonstration


    Setup

    Use the parameters below to set up the component.

    Parameters

    Select an existing Dynamics AX connection manager.

    Related Topics: Dynamics AX Connection Manager

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

    Action Description
    Create Create a new record in the destination table.
    Update Update an existing record in the destination table. The appropriate table record identifier must be specified for the update to work.
    Delete Delete an existing record from the destination table. The appropriate table record identifier must be specified for the delete to work.
    After changing the action, you must use the Refresh command in the 'Column Mappings' tab to reload the destination list metadata.

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

    Specify how to handle rows with errors.


    How to modify the destination table dynamically at runtime

    The destination table is available in the data flow properties list. Follow these steps to set up an expression:

    • Right-click on the data flow canvas and select the Properties menu.
    • Scroll down and find the property named like [Dynamics AX Destination].[DestinationTable]. This is the property containing the destination table.
    • Scroll down and find the Expressions property. Set up an expression to modify the destination table dynamically.

    Related documentation