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

Chapagain, Dilli R 96 Reputation points
2021-02-12T04:28:25.267+00:00

Hi,
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=12.0.0.0, 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.
67223-image.png
67210-image.png

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 11.0.0.0 and an indirect reference to version 12.0.0.0. Change the direct reference to use version 12.0.0.0 (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,611 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,665 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,901 Reputation points
    2021-02-12T06:24:15.983+00:00

    Hi @Chapagain, Dilli R ,

    1.Please try to set Target Server Version as SQL Server 2019.
    67303-targetserverversion.png

    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,
    Mona


    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.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.