Use of NAV Source Component

The NAV Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from the Microsoft Dynamics Business Central or Microsoft Dynamics NAV server. For the purpose of this documentation Microsoft Dynamics 365 BC/NAV will refer to both Microsoft Dynamics 365 Business Central and Microsoft Dynamics NAV.

The NAV Source Component includes the following two pages to configure how you want to read data from Microsoft Dynamics 365 BC/NAV.

  • General
  • Columns

General page

The General page of the NAV Source Component allows you to specify the general settings of the component. 

NAV Source Editor

NAV Connection Manager

The NAV source component requires a NAV connection in order to connect with the Microsoft Dynamics 365 BC/NAV server. The NAV Connection Manager option will show all DynamicsNAV connection managers that have been created in the current SSIS package.

Batch Size

The Batch Size option allows you to specify how many records you want to retrieve each time. The default value is 2000. For performance reasons, this parameter should not be too small.

Source Object

The Source Object option is only available after a NAV Connection Manager is selected. After you select a NAV Connection Manager, the component will retrieve a list of all available 365 BC/NAV pages & objects.

Note: You will only be able to see those page objects that you have enabled for integration. If you don't see a page object in the list, you would have to add a new Web Service entry for that page object in Dynamics NAV application by going to Web Services module. This is only applicable for integration with Microsoft Dynamics NAV server. When connected to Microsoft Dynamics 365 Business Central all available objects should be available without any additional set-up.

Page Filtering

The Page Filtering text box lets you specify filter criteria to help retrieve only the records you specify. The following is a sample of such filter.


Please see for more info on NAV filters.

Page Filtering now supports the use of User and System Variables. Simple select a variable under the Insert Variables drop down menu, and a placeholder value will be inserted into the filter text.

Supplementary Parameters

When working with specific object, there may be special parameters required in order to read from these objects (ex. General Journal object). These input values will be specified in the Supplementary Parameters area. The general format looks something like this:


Refresh Component Button

Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.

Columns page

The Columns page of the NAV Source Component shows you all available columns from the object that you specified on the General page. 

NAV Source Component - Columns