• rhythmk (9/12/2012)


    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.

    Problem is the excel file isnt ordered, but i need it in the order that the excel file is in 🙂

    So i cant order by.