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

/>
</OleDbDestination>
</Transformations>
</Dataflow>
<ExecuteSQL Name="Apply stgUpdates"
ConnectionName="SSISIncrementalLoad_Dest">
<PrecedenceConstraints>
<Inputs>
<Input OutputPathName="Load tblDest.Output"
/>
</Inputs>
</PrecedenceConstraints>
<DirectInput>
Update Dest
Set Dest.ColA = Upd.ColA
,Dest.ColB = Upd.ColB
,Dest.ColC = Upd.ColC
From tblDest Dest
Join stgUpdates Upd
On Upd.ColID = Dest.ColID
</DirectInput>
</ExecuteSQL>
</Tasks>
</Package>
</Packages>
</Biml>
We are now ready to test!
Testing the Biml
Testing the Biml will consist of generating the SSIS package, then executing it. We will
look at the data to see if the incremental load executed as expected. To begin, I have
prepared a T-SQL Reset Rows script shown in Listing 19-14 .
Listing 19-14 . Resetting the Incremental Load Source and Destination Values