Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Row number when importing a file using DTS

Author  Topic  Jonah Starting Member 3 Posts Posted - 2002-11-19 : 06:28:16 Hi all, I have a DTS package that imports from a text file to a table. One of the columns in the destination table is 'sequencenumber'. From this particular text file I need the SequenceNumber column to be populated with the row number of the record in the text file. e.g. the first row will have 1, the second 2 ..... I have implemented this by importing the file into an intermediate table which has an identity column representing the sequenceno. Then I copy the intermediate table to the destination table. I can't make the SeqenceNumber field on the destination table an Identity as it is populated from several other sources. The file will contain millions of records so am looking for any possible performance improvements. Any ideas how I could directly populate the destination table without the need for the intermediate one?