Share via

SSMS 20.1 Unable to see SSIS Execution Properties

Michel Lalancette 20 Reputation points
2024-05-07T12:59:51.8066667+00:00

Ever since I installed SSMS 20.1, I've been unable to look up the properties in SSIS jobs.

I'm aware that 20.1 has changed the way connections are made but my connection is set up with "Trust server certificate" and multiple menus error out.

I've also added Encrypt=False; in the additional connection parameters.

See attached image.

So far, the only workaround would be to install SSMS 19 but I'd rather be able to connect using the latest version.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,003 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,592 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 37,671 Reputation points
    2024-05-08T01:29:33.76+00:00

    Hi @Michel Lalancette，

    As said in the official documentation, the workaround is using SSMS 19.3 temporarily.

    Or you may wait for the new release which will fix the issue.

    User's image Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.