Could not load file or assembly 'Microsoft.SqlServer.Smo, Version= on SSIS2019

Chapagain, Dilli R 96 Reputation points

I have found many posts regarding my problem. However, I did not see any solution or answer. So, ask for some help to regard it.

I got a script task error at transfer the dim table from one server to another. Script task was working fine using SQL2014 and SSDT2013.

This error I get using SSMS2019 agent job
Error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

I have tried to build script task before build package/project
I also have the SMO version12 in the assembly folder.

Also some script task has this error "BC32207 The project currently contains references to more than one version of 'Microsoft.SqlServer.ConnectionInfo', a direct reference to version and an indirect reference to version Change the direct reference to use version (or higher) of Microsoft.SqlServer.ConnectionInfo. ScriptTask_7344b5f52f22478b98999e877c392cdb"
I am not sure how to change the reference to use the correct version?

I will appreciate any suggestion.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,323 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,459 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,881 Reputation points

    Hi @Chapagain, Dilli R ,

    1.Please try to set Target Server Version as SQL Server 2019.

    2.Please refer to the following link:
    Could not load file or assembly Microsoft.SqlServer.Smo version when configuring Orion database while using the Configuration Wizard

    Best Regards,

    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.