DTS Excel Import Problem (SQL Server 2K) Only First Row is imported

Question

Hi,

i have a Problem with the DTS Excel Import. I use a Excel data source and a Data Transformation Taks to import the data in an existing table.

First Error was a Buffer is too small because of a ntext column in the table, but i have set the fetch buffer size to 5 and the error was gone.

But now only the first row is imported, tha data is ok.

So someone hav an idea? I have read that ntext columns cant be imported but why does it work for the first data row?

Bye

Answer 1

퍽큐나먹어라시발새끼야