Business Intelligence Markup Language - SQL Server Integration Services Design Patterns - page 475

• dbo.Source1
• dbo.Source2
• dbo.Source3
Execute the T-SQL shown in Listing 19-17 to build and populate the SSISIn-
crementalLoad_Stage database.
Listing 19-17 . Building and Populating the SSISIncrementalLoad_Stage Database
Use master
Go
If Not Exists(Select name
From sys.databases
Where name
= 'SSISIncrementalLoad_Stage')
Create Database SSISIncrementalLoad_Stage
Go
Use SSISIncrementalLoad_Stage
Go
CREATE TABLE dbo.tblSource(
ColID int NOT NULL,
ColA varchar(10) NULL,
ColB datetime NULL,
ColC int NULL
)
CREATE TABLE dbo.stgUpdates_tblSource(
ColID int NOT NULL,
ColA varchar(10) NULL,
ColB datetime NULL,
ColC int NULL
)
Go