Create a SQL Server JOB using SSMS 20.X for a .dtsx package from the ssisdb server

Alen Cappelletti 971 Reputation points
2024-05-16T12:42:16.2333333+00:00

I installed SSMS 20.X and understood the problems connecting to the instance:
User's image

I am successfully connected. Now I would like to schedule a JOB with an integration services step (which I have done hundreds of times in the past)... but with SSMS versions lower than 20.

Even now if I launch for example SSMS 19.X I can create the step and the job without errors. The change in the 20.X release of SSMS is clear to me, but I cannot understand and resolve the error in the GUI using the 20.X release per the integration services STEP. I think it's something related to certificates.

I'm try to choose from default instance:
User's image

Can anyone give me some advice on how to overcome the error?

Thanks ALEN

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,134 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,566 Reputation points
    2024-05-16T23:31:41.7133333+00:00

    Hi @Alen Cappelletti,

    It is a bug in the SSMS 20 and 20.1

    It is documented in the SSMS 20 release notes: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#known-issues-201

    It better to stay with SSMS 19. Many people got burned by the SSMS 20

    Check it out here: https://learn.microsoft.com/en-us/answers/questions/1652988/sql-server-2022-certificate-error-when-creating-a

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,591 Reputation points
    2024-05-17T01:36:26.34+00:00

    Hi @Alen Cappelletti,

    It is a known issue and will be fixed in the next release, you may use SSMS19.3 temorarily.

    User's image

    Regards,

    Zoe Hui


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

    0 comments No comments