September 12, 2012 at 2:15 am
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
September 12, 2012 at 3:27 am
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
🙂
September 12, 2012 at 3:48 am
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.
September 12, 2012 at 4:33 am
Additionally.
My testing seems to suggest that it pulls the data off in excel order. Is this correct or just a coincidence?
Another question has arrived however?
Does this work the same with the ACE engine? I am currently using JET.
Dan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply