Could not load file or assembly 'Microsoft.SqlServer.Dmf.Common, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies

Question

Hi,

I am trying to execute a SSIS Package using PowerShell Script by following instructions mentioned in https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-deploy-powershell?view=sql-server-ver15

I have tried using the following commands to load Microsoft.SQLServer.Management.IntegrationServices.dll

$loadStatus = [System.Reflection.Assembly]::Load("Microsoft.SQLServer.Management.IntegrationServices.dll, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL")

$loadStatus = [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.Management.IntegrationServices") | Out-Null;

$loadStatus = [System.Reflection.Assembly]::LoadFrom("C:\Microsoft.SQLServer.Management.IntegrationServices.dll") | Out-Null

However, I get the following error:

New-Object : Could not load file or assembly 'Microsoft.SqlServer.Dmf.Common, Version=13.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

• ... nServices = New-Object $SSISNamespace".IntegrationServices" $sqlConne ...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : NotSpecified: (:) [New-Object], FileNotFoundException
• FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.NewObjectCommand

I don't have Microsoft.SqlServer.Dmf.Common.dll Version=13.0.0.0 in my machine.

Please let me know the solution for this error.

Thanks in advance.

Answer 1

Hi,

Have you ever tried Add-Type? 'Microsoft.SqlServer.Dmf.Common, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' is the strong name of the assembly. You could check it using the GetAssemblyName method.

[System.Reflection.AssemblyName]::GetAssemblyName($path).fullname  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I had this problem after migrating my work to a new laptop. What solved it was simply installing SQL Server 2019 Developer Edition (you can download it for free from Microsoft: https://www.microsoft.com/en-us/sql-server/sql-server-downloads). Be sure to include all the features which mention SDK and connectivity components. After I did this, the error went away.