1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
<#@ template language="C#" #>
<#@ import namespace="System.Data" #>
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Connections>
<!-- Creates a connection to the Adventure Works database -->
<Connection
Name="AdventureWorks"
ConnectionString="Provider=SQLNCLI10.1;Data Source=Localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW"
/>
</Connections>
<!-- Packages Collection -->
<Packages>
<!-- A Package -->
<Package
Name="MyFirstPackage"
ConstraintMode="Linear"
>
<!-- A Package's Tasks -->
<Tasks>
<ExecuteSQL Name="ExecuteStoredProc" ConnectionName="AdventureWorks">
<DirectInput>EXEC usp_StoredProc</DirectInput>
</ExecuteSQL>
<# foreach (var table in RootNode.Tables) { #>
<Dataflow Name="Duplicate <#=table.Name#> Data">
<Transformations>
<OleDbSource Name="Retrieve Data" ConnectionName="AdventureWorks">
<DirectInput>SELECT * FROM <#=table.Name#></DirectInput>
</OleDbSource>
<OleDbDestination Name="Insert Data" ConnectionName="AdventureWorks">
<ExternalTableOutput Table="<#=table.Name#>" />
</OleDbDestination>
</Transformations>
</Dataflow>
<# } #>
</Tasks>
</Package>
</Packages>
</Biml>
|
