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

And t.name = 'Package')
begin
/* Create custom.Package table
if it does not exist */
print ' - Creating custom.Package Table'
Create Table custom.Package
(
PackageID int identity(1,1)
Constraint PK_custom_Package Primary Key
Clustered
,FolderName nvarchar(128) Not Null
,ProjectName nvarchar(128) Not Null
,PackageName nvarchar(256) Not Null
,PackageDescription nvarchar(512) Null
)
print ' - Custom.Package Table created'
end
Else
/* If the custom.Package table exists, tell us */
print ' - Custom.Package Table already exists.'
print ''
/* Build custom.ApplicationPackage table */
print 'Custom.ApplicationPackage Table'
/* Check for existence of custom.ApplicationPackage table
*/
If Not Exists(Select s.name + '.' + t.name
From sys.tables t
Join sys.schemas s
On s.schema_id = t.schema_id
Where s.name = 'custom'
And t.name
= 'ApplicationPackage')
begin
/* Create custom.ApplicationPackage table
if it does not exist */
print ' - Creating custom.ApplicationPackage Table'
Create Table custom.ApplicationPackage