Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 489

Listing 20-3 . Manually Adding SSIS Application Metadata to the Framework
Use SSISConfig
Go
declare @ApplicationName varchar(255) = 'SSISApp1'
declare @ApplicationID int
/* Add the SSIS First Application */
If Not Exists(Select ApplicationName
From cfg.Applications
Where ApplicationName = @ApplicationName)
begin
print 'Adding ' + @ApplicationName
exec cfg.AddSSISApplication @ApplicationName,
@ApplicationID output
print @ApplicationName + ' added.'
end
Else
begin
Select @ApplicationID = ApplicationID
From cfg.Applications
Where ApplicationName = @ApplicationName
print @ApplicationName + ' already exists in the
Framework.'
end
print ''
Place this code into the FrameworkSQLGen.biml after the code in Listing 2. I need
to load this Transact-SQL into the stringbuilder variable (sb) and I need to make it gen-
eric by leveraging the variables in the include file. Accomplish this by loading the code
into the stringbuilder as shown in Listing 20-4 :
Listing 20-4 . Adding SSIS Application Metadata to the Stringbuilder
sb.AppendLine("Use SSISConfig");
sb.AppendLine("Go");
sb.AppendLine();