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

Name varchar(25) NULL,
Value int NULL
)
Go
INSERT INTO dbo.Source2
(ColID,Name,Value)
VALUES
(0, 'Willie', 11),
(1, 'Waylon', 22),
(2, 'Stevie', 33)
Go
CREATE TABLE dbo.Source3(
ColID int NOT NULL,
Value int NULL,
Name varchar(100) NULL
)
CREATE TABLE dbo.stgUpdates_Source3(
ColID int NOT NULL,
Value int NULL,
Name varchar(100) NULL
)
Go
INSERT INTO dbo.Source3
(ColID,Value,Name)
VALUES
(0, 101, 'Good-Hearted Woman'),
(1, 202, 'Are You Sure Hank Done It This Way?')
Go
Let's continue by adding a new Biml file to the Biml project. Rename this file
GenerateStagingPackages.biml . Before the <Biml> tag, add the code snip-
pet shown in Listing 19-18 .
Listing 19-18 . Adding .NET Namespaces and Initial Method Calls to Biml