Sort

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Packages>
        <Package Name="My Package" ConstraintMode="Linear" >
            <Tasks>
                <Dataflow Name="My Dataflow Task">
                    <Transformations>
                        <OleDbSource Name="FedReserve" ConnectionName="FederalReserveInstruments">
                            <DirectInput>select * from DimInstrument</DirectInput>
                        </OleDbSource>
                        <!-- Sorts the rows based using the Category column as the sort key -->
                        <Sort Name="Sort Transformation" EliminateDuplicates="true" >
                            <Columns>
                                <Column Sort="true" SourceColumn="Category" />
                            </Columns>
                        </Sort>
                        <FlatFileDestination Name="OutputFile" ConnectionName="FlatFileConnection" >
                        </FlatFileDestination>
                    </Transformations>
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>