<#@ 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>