MS SQL SERVER 2019 EXPRESS does not have Integration Services Catalog

Question

Hi,

I just installed MS SQL SERVER 2019 EXPRESS on my pc(windows 10), when I connect to it through SSMS, it does not have the Integration Services Catalogs node. But our company's database connection has it. I try to add features to it, but there is no SSIS feature. I downloaded/installed SSIS separately after I installed 2019 visual basic community. Do not know what goes wrong.

Could someone please help?

Thanks,

Samantha

Answer 1

Do you have Visual Studio 2019? Did you select SSDT? See Download SQL Server Data Tools (SSDT). If SSDT is installed with VS 219 then install Integration Services from within Visual Studio with Extensions > Manage Extensions.

I see that Install SQL Server Integration Services - SQL Server Integration Services (SSIS) says:

SSIS isn't included with the Express edition of SQL Server.

Answer 2

Hi @Samantha Smith ,

You may download a free Evaluation Edition, or the free Developer Edition, from SQL Server downloads.

SSIS isn't included with the Express edition of SQL Server.

More details for your referencce:

integration-services-features-supported-by-the-editions-of-sql-server

Regards，

Zoe

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October