AX 2012 R3 - Data Import Export Framework - Could not load file or assembly Microsoft.SQLServer.ManagedDTS, Version=11.0.0.0

Scenario

• A single server install of AX 2012 R3 used for Data Migration purposes
• SQL Server 2012 was originially installed on the server together with all DIXF Components
• SQL Server 2014 implemented (uninstall SQL Server 2012 Services and Shared Components and install SQL Server 2014 Services with Shared Components) - DIXF Components kept

After restoring databases from another AX solution and performing the needed operations on the databases, Preview in DIXF raised a Stop error in AX with the following message "Could not load file or assembly Microsoft.SQLServer.ManagedDTS, Version=11.0.0.0".

Solution

1. Stop the AOS instance
2. Reinstall (uninstall - install) DIXF Components
3. Start the AOS instance
4. Verify DIXF Preview functionality

Hypothesis

DIXF registers the reference (in AOT) to this SSIS assembly at DIXF install time.