How to import delimited text flat files

[Versys]

Hi everyone:

I need to import several flat files to a Microsoft SQL tables, at this moment I am using DTS, but this is kind of slow when you multiply the process for 20 tables, so, I am in need to know how to import these files in a expedite way such with a script.

Thanks.

 

[JohnDTampaBay]

Check out BULK INSERT and BCP in BOL. BULK INSERT is usually the quickest way to import text files into SQL tables. Good luck!

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Versys]

Thanks, that really work with most of my tables and I am saving lost of time by this method, but I have couple of tables with the following error "Bulk insert data conversion error (overflow)".

What should I do.

Once againg, Thanks.....