Also I have added an Environments table and changed the [SSIS_Config]

CREATE TABLE [dbo].[SSIS_Environments](

[EnvironmentId] [tinyint] NOT NULL,

[Environment] [nvarchar](10) NOT NULL,

[EnvironmentDesc] [varchar](11) NULL,

[HostName] [nvarchar](20) NULL,

[InstanceName] [nvarchar](20) NULL,

[ServerName] AS ([HostName]+coalesce('\'+[InstanceName],'')),

CONSTRAINT [PK_Environments]...

I like this solution and I am using it.

However the solution has a potential problem one needs to be aware of.

When you edit an existing SQL Server-based configuration from within...