Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Data Warehousing » Integration Services » Excel Import - row order
Add to briefcase

Excel Import - row order Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
danielfountain
Posted Wednesday, September 12, 2012 2:15 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: Today @ 4:14 AM
Points: 504, Visits: 588
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
rhythmk
Posted Wednesday, September 12, 2012 3:27 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603
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
danielfountain
Posted Wednesday, September 12, 2012 3:48 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: Today @ 4:14 AM
Points: 504, Visits: 588
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
danielfountain
Posted Wednesday, September 12, 2012 4:33 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: Today @ 4:14 AM
Points: 504, Visits: 588
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.