• Sort the records from a table using ORDER BY in OLE DB Source component before sending rows to excel spreadsheet

    e.g., SELECT cols......

    FROM your_table_name

    ORDER BY column_name you want to order

    Above statetment should be in OLE DB Source in a Data Flow Task