web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Microsoft Dyncamics AX...
Microsoft Dynamics AX (Archived)

Microsoft Dyncamics AX Data migration Tool using SQL Server 2012

(0) ShareShare
ReportReport
Posted on by Community Member

hi,

we installed the brand new Data migration Tool as described on the technet document ation on our AX2012 environment, but we are using SQL Server 2012.

When performing the preview (and the same happens when importing into staging tables) the following error comes out:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

File name: 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

at Microsoft.Dynamics.AX.DMF.SSISHelper.DMFEntity.ShowPreview()

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


I checked and can confirm that the required assembly of SSIS is not present.

Is there some workaround the tool can be used with SQL Server 2012?

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Kevin Kidder Profile Picture
    Kevin Kidder on at

    This message would need to be posted using the Feedback link on the location where you downloaded the utility. Support for any of the beta tools released there is handled through that interface.

    Kevin

  • Tito Profile Picture
    Tito 135 on at

    I have the same error, they added the Integration Services on the features that must be available, it wasn't there before. But I am still getting the same error, even after installing it.

  • Community Member Profile Picture
    Community Member on at

    I am getting the same error, but i am using SQL 2008 R2.

    Any suggestions/ Anyone got the issue resolved? !!!

    Error :

    System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    File name: 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

      at Microsoft.Dynamics.AX.DMF.SSISHelper.DMFEntity.MigrateEntity()

    WRN: Assembly binding logging is turned OFF.

    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

    Note: There is some performance penalty associated with assembly bind failure logging.

    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

  • Suggested answer
    Kevin Kidder Profile Picture
    Kevin Kidder on at

    If you search the feedback information from the Feedback link on the InformationSource website where you downloaded the DMF tool, feedback has been posted that as of 8/1 the beta version available does not support Microsoft SQL Server 2012 but will in the future. Also, the SSIS components must be loaded on the AOS machine itself for the beta version, and that limitation also will be removed in the future.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans