CODEWITHSUNDEEP
sql-serverssisssmsetlsql-server-express
Marcel
Marcel

Reputation: 65

SQL Server Express and created SSIS package

I created with the import tool (SQL Server 2019 Express, SSMS 18.1) some SSIS import packages for testing. Now I want to delete them that they can‘t be used by accident.

Of course, I know I have no SSIS running, but when the packages are created by the SQL Server Management Studio they must be stored somewhere. How can I delete them?

Upvotes: 2

Views: 734

Answers (1)

Hadi
Hadi

Reputation: 37313

I can only give the package a name and can‘t decide where, so I think there is a standard location.

By default, SSIS packages created using the Import/Export wizard are stored within the MSDB database.

enter image description here

To access the stored packages, you should connect to Integration Services from the SQL Server Management Studio.

enter image description here

Then you should see the stored packages within the MSDB directory as shown below.

enter image description here

More information can be found in the following articles:

Upvotes: 2

Related Questions