Database Reference
In-Depth Information
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
If Not Exists(Select AppPackageID
From cfg.AppPackages
Where ApplicationID = @ApplicationID
And PackageID = @PackageID
And ExecutionOrder = @ExecutionOrder)
begin
print 'Adding ' + @ApplicationName + '.' + @PackageName
+ ' to Framework with ExecutionOrder ' + convert(varchar,
@ExecutionOrder)
exec cfg.AddSSISApplicationPackage @ApplicationID,
@PackageID, @ExecutionOrder
print @PackageName + ' added and wired to '
+ @ApplicationName
end
Else
print @ApplicationName + '.' + @PackageName
+ ' already exists in the Framework with ExecutionOrder '
+ convert(varchar, @ExecutionOrder)
Search WWH ::




Custom Search