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

exec cfg.AddSSISPackage @PackageName, @PackageFolder,
@PackageID output
end
Else
begin
Select @PackageID = PackageID
From cfg.Packages
Where PackageFolder = @PackageFolder
And PackageName = @PackageName
print @PackageFolder + @PackageName + ' already exists
in the Framework.'
end
set @PackageName = 'Child2.dtsx'
/* Add the Child2.dtsx SSIS Package*/
If Not Exists(Select PackageFolder + PackageName
From cfg.Packages
Where PackageFolder = @PackageFolder
And PackageName = @PackageName)
begin
print 'Adding ' + @PackageFolder + @PackageName
exec cfg.AddSSISPackage @PackageName, @PackageFolder,
@PackageID output
end
Else
begin
Select @PackageID = PackageID
From cfg.Packages
Where PackageFolder = @PackageFolder
And PackageName = @PackageName
print @PackageFolder + @PackageName + ' already exists
in the Framework.'
End
We now have enough to test the next step of my SSIS Execution and Monitoring
Framework, so let's returning to SSDT. Add an Execute SQL task to the control flow
and rename it Get PackageMetadata . Open the editor and change the ResultSet prop-
erty to Single row. Change the ConnectionType property to ADO.Net. Click the drop-
down in the Connection property and click <New connection…>. Configure an