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

,ColB
,ColC
FROM dbo.tblSource

Go

Use SSISIncrementalLoad_Dest
Go

SELECT TableName = 'tblDest'
,[ColID]
,[ColA]
,[ColB]
,[ColC]
FROM [dbo].[tblDest]

SELECT TableName = 'stgUpdates'
,[ColID]
,[ColA]
,[ColB]
,[ColC]
FROM [dbo].[stgUpdates]

Go

Executing the test script after executing the reset script yields the results pictured in
Figure 19-4 .

Figure 19-4 . Pre-SSIS-Package-Execution results of test script