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

Listing A-14 . Append This T-SQL Script to Listing A-11 to Add the ErrorTest.dtsx SSIS
Package to the SSISApp1 SSIS Application
/*ErrorTest.dtsx */
/* Variable Declaration */
declare @PackageFolder varchar(255)
= 'F:\Andy\Projects\PublicFramework_PackageDeployment_2014\SSISConfig2014\'
declare @PackageName varchar(255) = 'Child1.dtsx'
declare @PackageID int
declare @ExecutionOrder int = 10
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 ''
set @PackageName = 'ErrorTest.dtsx'
set @ExecutionOrder = 30
If Not Exists(Select PackageFolder + PackageName