Post reply

how to avoid sort transformations

  • August 25, 2012 at 10:47 pm

    #263345

    Can anyone tell me :- "How to export Records from a table of a database to an excel file sorted based on First Name(column name) without using SORT transformation

  • August 26, 2012 at 4:39 am

    #1530104

    SSIS homework?

    Odd request, if I want the rows sorted, they have to be sorted somewhere...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 27, 2012 at 7:18 am

    #1530333

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply