Varigence, Inc.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Packages>
        <Package Name="My Package" ConstraintMode="Linear">
            <Tasks>		
                <Dataflow Name="My Dataflow Task">
                    <Transformations>
						<OleDbSource Name="SurveyResponses" ConnectionName="SportsData">
							<Columns>
                                <Column SourceColumn="SurveyId" SortKeyPosition="1" />
                                <Column SourceColumn="Attribute" SortKeyPosition="2" />
                                <Column SourceColumn="Response" SortKeyPosition="3" />
								<Column SourceColumn="NewResponse" SortKeyPosition="0" TargetColumn="NewReponse" />
							</Columns>
							<DirectInput>select * from SurveyResponses order by surveyid, attribute, response</DirectInput>
		                </OleDbSource>
					
						<!-- Performs a parameterized query lookup on JuniorSurveryResponses over the AttributeColumn, 
							 mapping the resulting Response column to NewResponse.  The parameter maps to the SurveyId column -->
						<Lookup Name="Lookup Transformation" OleDbConnectionName="SportsData" NoMatchBehavior="IgnoreFailure" CacheMode="None">
                            <ParameterizedQuery>
                                select * from JuniorSurveyResponses where SurveyId = ?
							</ParameterizedQuery>
							<Parameters>
								<Parameter SourceColumn="SurveyId" TargetColumn="Parameter0" />
							</Parameters> 
							<Inputs>
                                <Column SourceColumn="Attribute" TargetColumn="Attribute" />
								<Column SourceColumn="SurveyId" TargetColumn="SurveyId" />
							</Inputs>
							<Outputs>
                                <Column SourceColumn="Response" TargetColumn="NewReponse" />
							</Outputs>
							<InputPath OutputPathName="SurveyResponses.Output" />
							
							<DirectInput>select * from JuniorSurveyResponses</DirectInput>
						</Lookup>
						<FlatFileDestination Name="OutputFile" ConnectionName="FlatFileConnection" Overwrite="true">
							<Columns>
								<Column SourceColumn="SurveyId" TargetColumn="SurveyId" />
                                <Column SourceColumn="Attribute" TargetColumn="Attribute" />
                                <Column SourceColumn="Response" TargetColumn="Response" />
                                <Column SourceColumn="NewResponse" TargetColumn="NewResponse" IsUsed="true" />
							</Columns>
						</FlatFileDestination>
						
                    </Transformations>
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>