Dynamics NAV Destination

Overview

The Dynamics NAV Destination Component is an SSIS Data Flow Component for loading data into the Microsoft Dynamics NAV page. The configuration parameters are provided in the standard Data Flow Component dialogs.

For writing data to Microsoft Dynamics Business Central, it is now recommended to use REST Destination with Business Central configuration.

Parameters

Configuration

Use the parameters below to configure the component.

DYNAMICS-NAV

Select an existing Dynamics NAV connection manager.

Related Topics: Dynamics NAV Connection Manager

Action

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

Action	Description
Create	Create a new record in the destination page.
Update	Update an existing record in the destination page. The appropriate page record key must be specified for the update to work.
Delete	Delete an existing record from the destination page. The appropriate page record key 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 page metadata.

DestinationPage

Specify the destination Dynamics NAV page where the data is to be loaded.
BatchSize

Specify the number of rows to be sent as a batch.
ErrorRowDisposition (Dynamics NAV Destination Input)

Specify how to handle rows with errors.
Id (Dynamics NAV Destination Error Output)

Contains the unique identifier of the added, updated or deleted record.

Knowledge Base

What's New

1.6 SR-4

Fixed: Component failed when the input data contained newline character (Thank you, Lars).

1.6

New: Introduced component.

SSIS+ Components Suite

SSIS NoW

Excel Add-in for SAS

Overview

Parameters

Configuration

Knowledge Base

What's New

Newsletter

Contact Us

Follow Us

Support

SSIS+ Components Suite

SSIS NoW

Excel Add-in for SAS

Dynamics NAV Destination

Overview

Parameters

Configuration

Knowledge Base

What's New

Related documentation