Importing Text File to Database Causes Out of Space Error

Question

When I try to import Text File into SQL Server 2000 using DTS, it gives me the following error

Not enough storage available to complete this operation

Any suggestions?

Answer 1

See this:

As it turns out the problem lies with the DTS wizard when importing text files it set the fields as varchar and a size of 8000!!!!!!!

I changed them (all 236 of them) to 255 and hey presto!