Hi!

I was pointed in this direction from microsoft.public.windows.server.sbs

I have a question about automating importing text files into a table in SQL
Server. I`m a complete SQL server "noob" but I am looking for a way to
import all
the data from a set of text files in a folder, then to either move or rename
the files once they have been imported.

Every day our PBX phone system logs all activity into a .CSV text file. At
midnight a new text file is created for the next 24 hours logging.

Whilst i can manually import each text file into a table in SQL server using
DTS there must be a way to automate this ?

Does anyone have a solution, or maybe point me in the direction of a
newsgroup that will be able to assist further.

Many thanks

Geoff

Try this article to help build a package that handles all of this sort of
file handling-

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

Once done, schedule the package via SQL Server Agent.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Geoff Dutch" <GeoffDutch (AT) discussions (DOT) microsoft.com> wrote

I was looking at that page over lunch time after having searched the NG.
Unfortuanately i understand next to nothing of it aside from the summary of
what it does. I would need someone holding my hand showing me what goes
where and how to do it as i`m a total noob on SQL !!

"Darren Green" wrote: