SQL server SSIS package information store in database. To create the SSISDB catalog in SQL Server Management Studio Open SQL Server Management Studio. Connect to the SQL Server Database Engine. In Object Explorer, expand the server node, right-click the Integration Services Catalogs node, and then click Create Catalog. Click Enable CLR Integration.The catalog uses CLR stored procedures. Click Enable automatic …
Generating scripts using T-SQL statements This script may returned to 8192 the maximum character. Generating script for Role and memberships Generating script for permission
It’s Important to check you are not blocking all users to connect to the server You can check how trigger use on the server Other References:
There are some tables in MSDB database which we can use for generating scripts msdb.dbo.sysmail_profilemsdb.dbo.sysmail_profileaccountmsdb.dbo.sysmail_accountmsdb.dbo.sysmail_server
