• danielfountain (9/12/2012)


    Hey all,

    When you import data from SSIS - how does it work with the row order?

    Does the row order stay the same in the excel file as it would be in the database table (as a heap)?

    Is there any way to make sure it does stay in the same order?

    Many thanks

    Dan

    To maintain the order use order by clause in the select statement.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂