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

Set Identity_Insert cfg.Packages ON
Insert Into cfg.Packages
(PackageID
,PackageFolder
,PackageName)
Values
(0
,'\'
,'parent.dtsx')
Set Identity_Insert cfg.Packages OFF
print '0 row for cfg.Packages added'
end
Else
print '0 row already exists for cfg.Packages'
print ''
If Not Exists(Select AppPackageID
From cfg.AppPackages
Where AppPackageID = 0)
begin
print 'Adding 0 row for cfg.Packages'
Set Identity_Insert cfg.AppPackages ON
Insert Into cfg.AppPackages
(AppPackageID
,ApplicationID
,PackageID
,ExecutionOrder)
Values
(0
,0
,0
,10)
Set Identity_Insert cfg.AppPackages OFF
print '0 row for cfg.AppPackages added'
end
Else
print '0 row already exists for cfg.AppPackages'
print ''