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

Use SSISIncrementalLoad_Source
Go
TRUNCATE TABLE dbo.tblSource
-- insert an "unchanged" row, a "changed" row, and
a "new" row
INSERT INTO dbo.tblSource
(ColID,ColA,ColB,ColC)
VALUES
(0, 'A', '1/1/2007 12:01 AM', -1),
(1, 'B', '1/1/2007 12:02 AM', -2),
(2, 'N', '1/1/2007 12:03 AM', -3)
Use SSISIncrementalLoad_Dest
Go
TRUNCATE TABLE dbo.stgUpdates
TRUNCATE TABLE dbo.tblDest
-- insert an "unchanged" row and a "changed" row
INSERT INTO dbo.tblDest
(ColID,ColA,ColB,ColC)
VALUES
(0, 'A', '1/1/2007 12:01 AM', -1),
(1, 'C', '1/1/2007 12:02 AM', -2)
Listing 19-15 contains the test script we will use to examine and compare the con-
tents of the Source and Destination.
Listing 19-15 . Test Script for the IncrementalLoad.dtsx SSIS Package
Use SSISIncrementalLoad_Source
Go
SELECT TableName = 'tblSource'
,ColID
,ColA