CODEWITHSUNDEEP
databasessisbusiness-intelligencemsbi
Ranju
Ranju

Reputation: 81

How to import Excel to Database using SSIS without changing row order !!?

Actually i am importing EXcel to Data Base using SSIS

But its changing the Row order so is there any way to restrict without changing the row order!

Please don't give hit (-) if its duplicated question in Stack overflow Thanks (+1)

Upvotes: 0

Views: 168

Answers (1)

Mark He
Mark He

Reputation: 741

The order of rows in the database do not matter. Relational tables are un-ordered sets rather than ordered lists (like Excel). Even if you import the data a certain way into the database, the order of the data is random and can change. If you want the data to appear a certain way, simply use a SELECT statement with an ORDER BY of your choice.

Upvotes: 2

Related Questions