file importing problem in SQL Server..

[Marcia]

hi ..

i have a problem while using the DTS in SQLserver.i have a text fie to be imported into a table.
This text file that is to be imported contains 50000 records.
When i try to import that text file contents into a table,only 30864 records are getting imported.
can anybody help me out in this issue..

thanks,
Marcia

[hspc]

What is the error message that you get (if any)
What is the table schema?
How is your text file is delimited?
does the data in the 30865th record differ somehow from data before?
Without enough information it's unlikely that you'll get any useful help.