Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel Import - row order Expand / Collapse
Author
Message
Posted Wednesday, September 12, 2012 2:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:49 AM
Points: 769, Visits: 849
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
Post #1357833
Posted Wednesday, September 12, 2012 3:27 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 6, 2014 6:14 AM
Points: 564, Visits: 888
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

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1357858
Posted Wednesday, September 12, 2012 3:48 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:49 AM
Points: 769, Visits: 849
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.
Post #1357866
Posted Wednesday, September 12, 2012 4:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:49 AM
Points: 769, Visits: 849
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
Post #1357883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse