DTS Import "scrabbles" data. Any Ideas ?

[MrJRW]

I would like to import data to a SQL Server 2000 table.

I have the source data in a text file, tab-delimited and as an Excel 2000 file.

The data is sorted.

When I import, using eirther the Excel file or the text file, the data rows get "scrabbled".

Any ideas why this is happening ??

Thanks

 

[JayKusch]

Is there an clustered index on the table you are importing the data into. If so, that is the culprit.

Thanks

J. Kusch

 

[MrJRW]

You are correct. In fact, there weren't ANY indexes on that table.

Putting on a clustered index did the trick.

Thanks !

JRW