Monday, February 2, 2015

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.