flatfile in dataflow task

• forum member

  Ten Centuries

  Points: 1290

  More actions

  January 4, 2010 at 5:23 pm

  #141404

  Hi,

  The flatfile data order was changed when imported to the table through dataflow task.Would like to know what is the reason for this scenario,but didn't happened same for other file imports

  Thanks

• john.arnott

  SSChampion

  Points: 11882

  More actions

  January 4, 2010 at 7:05 pm

  #1098725

  When you say the order was changed, did you mean that a select from the table returns the rows in a different sequence than they were in the flatfile? If so, the answer is simply that a SQL Server table has NO GUARANTEE OF ORDER for a query without using the ORDER BY clause. Although, especially with smaller tables, you may often see data returned in the same sequences as it was inserted, there is no implicit order.

  If you want the data returned from SQL Server in a particular order, specify it with ORDER BY.