Sample Header Ad - 728x90

Install other SMO versions to avoid SSIS errors under SSMS 19?

0 votes
0 answers
40 views
Connecting to an older sql version's Integration Services instance will throw the Class Not Registered error and the Properties for a sql agent SSIS job step will not show (e.g. DataSources). This is due to the SMO objects installed with SSMS...they have to match the version of sql (e.g. SSMS 19 is v16, so works with SQL 2022 SSIS instances). If I have SSMS 19 (SMO v16) installed, can I also install the SMOs for older versions to avoid the class not registered error when connecting from SSMS 19 to SSIS 2019, 2016, etc.? The workaround is to also install the older versions of SSMS (18 is SMO v15 for SQL 2019, etc.) but that's cumbersome. Thanks!
Asked by Bobogator (95 rep)
Feb 18, 2025, 02:14 PM