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.
12,898 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,626 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.