• That's an interesting idea. I think I would have it script out the command with the current values:

    DECLARE @filter NVARCHAR(100)

    SET @filter = N'InsertYourConfigurationFilterHere'

    SELECT REPLACE(

    N'EXEC dbo.SSIS_Config_SetValues N''' + ConfigurationFilter + ''',|N''' + PackagePath + ''''

    + CASE WHEN GlobalValue IS NULL THEN '' ELSE ',|@AllValues = N''' + GlobalValue + '''' END

    + CASE WHEN ProductionValue IS NULL THEN '' ELSE ',|@ProdValue = N''' + ProductionValue + '''' END

    + CASE WHEN DevelopmentValue IS NULL THEN '' ELSE ',|@DevValue = N''' + DevelopmentValue + '''' END

    + CASE WHEN TestValue IS NULL THEN '' ELSE ',|@TestValue = N''' + TestValue + '''' END, '|', CHAR(10))

    FROM dbo.SSIS_Config_AllEnv

    WHERE ConfigurationFilter = @filter