MicrosoftMicrosoftI love the new UI and the organization of code and queries is much easier. I still haven't tried copilot, but that's more of a company issue we have on our end.
I came across an issue today that I can't seem to resolve either with a re-install or reboot (currently on SQL Server Management Studio 21.4.8+5.36301.6). When I open the Jobs node in the SQL Server Agent, open a job, and try opening a step in the job, the step dialog comes up empty. Is anyone else experiencing this? I find this to be a moderate obstacle because I frequently reference steps to know what is running to debug jobs.
UPDATE: It appears my problem stems from a missing SSIS component. Most of the SQL Server Agent jobs we have run SSIS packages. If that component is missing, not only will I not be able to see the associated package in the job step, I will also not be able to configure the job for SSIS package execution in the step. Is anyone else encountering this issue?
Microsoftheashon2000 You need to modify your SSMS installation using the Visual Studio Installer to add the SSIS component. We made that available in a previous release, but we don't automatically install it (we don't assume that everyone uses SSIS). Once you modify your installation, you should be able to see everything.
BINGO!! That worked!! Thanks Erin!
