While using D365FO on premises, users may get below error while import and export of files.
System.Exception: Could not load file or assembly ‘Microsoft.SqlServer.ManagedDTS, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.at Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntitySharedTypesProxy.DoWork[T](Func`1 work) at Dynamics.AX.Application.DMFGenerateSSISPackage.`generateFileDataV2Inner (DMFDefinitionGroupExecution dmfDefinitionGroupExecution, String defGroupName, DMFFileFormat fileFormat, DMFDelimiter rowDelimiter, DMFDelimiter columnDelimiter, String codePage, String locale, NoYes isFirstRowHeader, NoYes unicode, String source, String textQualifier, DMFXMLStyle style, String rootElement, String filePath, Map entitySyncVersion, Int32 previewCount, Boolean _updateOnError) in xppSource://Source/ApplicationFoundation\AxClass_DMFGenerateSSISPackage.xpp:line 1404
Solution:
1- Install SSIS from SQL installer
2- Refresh Data entity parameters.
management workspace > Framework parameters > Entity settings > Refresh entity list