Folders table in SSISDB

A folder table contains one or more projects and environments in the SSISDB catalog. We can use the catalog.folders (SSISDB Database) view to access information about folders in the catalog.

  

select * from internal.folders

This table is having information of the project folder like project name, description which we give at deployment time, created by and created time.

Let’s see a simple example

Here I am creating a simple package and deploying this package in the server.

Now I am deploying this Package.

  

Package deploy successfully

  

Now I see the folders table

    

 We can use the following stored procedures to manage folders.

Ø  catalog.create_folder

Ø  catalog.delete_folder

Ø  catalog.rename_folder

Ø  catalog.set_folder_description