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

Question

I installed SSMS 20.X and understood the problems connecting to the instance:

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:

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

Thanks ALEN

Answer 1

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

Answer 2

Hi @Alen Cappelletti,

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

Regards，

Zoe Hui

---

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