<#@ template language="C#" hostspecific="True"#>
<#@ import namespace="Varigence.Languages.Biml.Connection" #>
<#@ import namespace="Varigence.Hadron.Extensions" #>
<#@ import namespace="Varigence.Hadron.Extensions.SchemaManagement" #>
 
<#+ public ImportResults Results
    { 
        get 
        {   
            return ((AstOleDbConnectionNode)RootNode.Connections["AdventureWorksLT"]).ImportDB();
        }
    }
#>  
     
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Schemas>
        <#=Results.SchemaNodes.GetBiml()#>
    </Schemas>
    <Tables> 
        <#=Results.TableNodes.GetBiml()#>
    </Tables>
</Biml>

*** Add a connection.  For the above snippet to work you will need to do the following:
In BIDS Helper:
1. Add a new Biml file to your project.
2. Add the Biml below to the new file.
3. If needed, edit the database and connection string.
4. Select both files before executing the Biml.

Note:  The above snippet will not generate a package in BIDS.  Since it is generating BIML in memory, another
Biml script in Teir 2 will be required to generate a package(s) from the snippet above.

In Mist:
1. Add a Connection to your Mist project or change the name of the connection in the snippet from AdventureWorksLT to one already in your project.
2. Either Execute the snippet to create the biml files in your project or convert it to a Live BimlScript.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<OleDbConnection
			Name="AdventureWorksLT"
			ConnectionString="Data Source=localhost;Initial Catalog=AdventureWorksLT;Provider=SQLNCLI10.1;Integrated Security=SSPI;Connect Timeout=30;"/>
	</Connections>
</Biml>