Sha256: 3931dc2687b6001857a6f8602d887857f8b5cca37eccb25404299f88c4c74803
Contents?: true
Size: 1.63 KB
Versions: 75
Compression:
Stored size: 1.63 KB
Contents
<#@ 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>
Version data entries
75 entries across 73 versions & 8 rubygems