Execution Patterns - SQL Server Integration Services Design Patterns - page 61

(
ApplicationPackageID int identity(1,1)
Constraint PK_custom_ApplicationPackage Primary
Key Clustered
,ApplicationID int Not Null
Constraint FK_custom_ApplicationPackage_Application
Foreign Key References
custom.Application(ApplicationID)
,PakcageID int Not Null
Constraint FK_custom_ApplicationPackage_Package
Foreign Key References custom.Package(PackageID)
,ExecutionOrder int Not Null
Constraint
DF_custom_ApplicationPackage_ExecutionOrder
Default(10)
,ApplicationPackageEnabled bit Not Null
Constraint
DF_custom_ApplicationPackage_ApplicationPackageEnabled
Default(1)
)
print ' - Custom.ApplicationPackage Table created'
end
Else
/* If the custom.ApplicationPackage table exists, tell
us */
print ' - Custom.ApplicationPackage Table already
exists.'
print ''
/* Build custom.GetApplicationPackages stored procedure */
print 'Custom.GetApplicationPackages'
/* Check for existence of custom.GetApplicationPackages
stored procedure */
If Exists(Select s.name + '.' + p.name
From sys.procedures p
Join sys.schemas s
On s.schema_id = p.schema_id
Where s.name = 'custom'