Thanks Rajesh for your very valuable help

I had posted the same problem, recently, under SQL Server - General, as shown below:

"Has anybody come across this curious problem:

I am running SQL Server 2000 on various P3 and...

I am running the Personal Edition. When QA exits, isqlw disappears from the task manager, but clickng on the "Performance" tab shows that the real memory used (in my case...

Hi all,

I have found out a more efficient way of importing text files into tables, which avoids the problem of right string truncation raising an error condition and stopping the...

quote:

---

Hi,

are you doing this within a transaction? If so, could it be that you need to reset the Err.Object to 0 before...

Thanks very much, it works

The curious thing is that when this type of error is encountered using the Bulkcopy object from VB, it does not import anything....

The problem is that I don't know, a priori, what the text length is; the imported file is an ascii file delimited with a vertical bar. The lengths of the...