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
