Database Reference
In-Depth Information
Adding Metadata
In this section, we will
• Add metadata that defines the connection managers used in the incre-
mental load SSIS design pattern.
• Add a new Biml file to the Biml project and rename it
Increment-
alLoad.biml
.
• Add a Connections XML node just after the
<Biml>
tag.
• Add two Connection XML nodes configured to connect with the
SSISIncremental_Source
and
SSISIncremental_Dest
databases.
Your code should appear as shown in
Listing 19-6
.
Listing 19-6
.
Configured Connections for IncrementalLoad.biml
<Biml xmlns="
http://schemas.varigence.com/biml.xsd
">
<Connections>
<Connection Name="SSISIncrementalLoad_Source"
ConnectionString=
"Data Source=(local);Initial
Catalog=SSISIncrementalLoad_Source;Provider=
SQLNCLI11.1;Integrated Security=SSPI;" />
<Connection Name="SSISIncrementalLoad_Dest"
ConnectionString=
"Data Source=(local);Initial
Catalog=SSISIncrementalLoad_Dest;Provider=
SQLNCLI11.1;OLE DB Services=1;Integrated
Security=SSPI;" />
</Connections>
</Biml>
Add a Packages node between the
</Connections>
and
</Biml>
tags. Just
after, add a Package XML node followed by a Tasks node. Immediately thereafter, add
an ExecuteSQL node configured as shown in
Listing 19-7
.
Search WWH ::
Custom Search