Database Reference
In-Depth Information
the SSIS Package.
Description: Stores an SSIS Package.
Example: exec custom.AddPackage 'Chapter2',
'Chapter2'
,
'Chapter2.dtsx', 'A test SSIS Package.'
*/
Create Procedure custom.AddPackage
@FolderName nvarchar(128)
,@ProjectName nvarchar(128)
,@PackageName nvarchar(256)
,@PackageDescription nvarchar(512) = NULL
As
begin
Set NoCount On
Insert Into custom.Package
(FolderName
,ProjectName
,PackageName
,PackageDescription)
Output inserted.PackageID
Values
(@FolderName
,@ProjectName
,@PackageName
,@PackageDescription)
end
go
print ' - Custom.AddPackage Stored Procedure created.'
print ''
/* Build custom.AddApplicationPackage stored procedure */
print 'Custom.AddApplicationPackage'
If Exists(Select s.name + '.' + p.name
Search WWH ::
Custom Search