Configure the version of SSIS used by the AX 2012 Data import/export framework

This topic only applies to environments that are running Microsoft Dynamics AX 2012 R2 with KB 3018235 installed. KB 3018235 is required to use Data Import/Export Framework for AX 2012 R2 CU7 with SQL Server 2014 Integration Services. If you are in an environment in which two versions of Microsoft SQL Server Integration Services are installed on the same computer, by default, the Data Import/Export Framework Windows service will attach to the oldest version of Integration Services that it can find. SQL Server 2008 Integration Services is the oldest supported version. You can force the Data Import/Export Framework to use another version of Integration Services by using redirecting assembly versions. We strongly recommend that you use Data Import/Export Framework in an environment with only one version of SQL Server Integration Services installed. To see which versions of Integration Services are supported with the Data Import/Export Framework, see the Microsoft Dynamics AX 2012 System Requirements.

Force the Data import/export framework to use a version of Integration Services other than the default

You can force the Data Import/Export Framework to use a version of Integration Services other than the default by redirecting assembly versions.

Caution:
If the assembly version redirection is setup incorrectly, for example, by redirecting to a version of Integration Services that is not installed, the Data Import/Export Framework will not work correctly.
  1. Locate the installation directory of the Data Import/Export Framework service component.
  2. Open the file Microsoft.Dynamics.AX.DMF.SSISHelperService.exe.config in a text editor.
  3. Locate the <runtime> element in the file. Inside this element, add the following code.

    • Code to redirect to SQL Server 2012 Integration Services

    • Code to redirect to SQL Server 2014 Integration Services

  4. Save the file.

  5. Restart the Data Import/Export Framework service.
  6. Test that your changes are working as expected.