<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Annotations>
<Annotation>
File: Add.RowNumber.Include.biml
Demo on using the Include file
Enviroment:
DB: MS-SQL2012
BIML: 1.6 VS2010 BIDS Helper
(c) John Minkjan biml101.blogspot.com
</Annotation>
</Annotations>
<FileFormats>
<#@ include file="C:\BIML\FFF\FFF AdventureWorks2012 Person Address.txt" #>
</FileFormats>
<Connections>
<#@ include file="C:\BIML\CN\CnOleDBAdventureWorks2012.txt" #>
<FlatFileConnection Name ="CnFFAdventureWorks2012PersonAddress"
FileFormat ="FFF AdventureWorks2012 Person Address"
FilePath="C:\AdventureWorks2012.Person.Address.dat"></FlatFileConnection>
</Connections>
<Packages>
<Package Name="Add.RowNumber.Include" ConstraintMode="Linear">
<Tasks>
<Dataflow Name="DFT Add Rownumber">
<Transformations>
<OleDbSource Name ="ODS AdventureWorks2012 Person Address"
ConnectionName ="CnOleDBAdventureWorks2012">
<DirectInput>
SELECT [AddressID]
File: Add.RowNumber.Include.biml Demo on using the Include file Enviroment: DB: MS-SQL2012 BIML: 1.6 VS2010 BIDS Helper (c) John Minkjan biml101.blogspot.com also published here: http://biml101.blogspot.nl/2012/09/biml-include.html

Comments
There are no comments yet.