Database Reference
In-Depth Information
begin
print 'Dropping cfg.AddSSISApplicationPackage stored
procedure'
Drop Procedure cfg.AddSSISApplicationPackage
print 'Cfg.AddSSISApplicationPackage stored procedure
dropped'
end
print 'Creating cfg.AddSSISApplicationPackage stored
procedure'
go
Create Procedure cfg.AddSSISApplicationPackage
@ApplicationID int
,@PackageID int
,@ExecutionOrder int = 10
As
Set NoCount On
If Not Exists(Select AppPackageID
From cfg.AppPackages
Where ApplicationID = @ApplicationID
And PackageID = @PackageID)
begin
Insert Into cfg.AppPackages
(ApplicationID
,PackageID
,ExecutionOrder)
Values (@ApplicationID, @PackageID, @ExecutionOrder)
end
go
print 'Cfg.AddSSISApplicationPackage stored procedure
created.'
print ''
To create the mappings between SSIS applications and SSIS packages, you need
the IDs of each. Executing the following queries returns the information you need:
Search WWH ::
Custom Search