Schedule Auto Import of new Log / Text files into SQL Server

[newprog1]

Hi Everyone,

Problem:

Basically we have a SQL Server Database on our telecoms switch, to which under the maintenance contract we have no direct access. Every 15 mins log files are downloaded in *.log files (text files) which contain data we can upload to our own databases for querying. The log files are on an ftp server.

Requirement :

In short I would like to know the best way to automatically update my own SQL Server database with the new log files as they appear or if there is some existing sooftware which allows this type of schedule and auto import. I would be very greatful if someone can give me some ideas with this problem as it would save me so much time.



Thanks in advance

 

[philhege]

I take it you've written a batch file to FTP the log files to your domain.

What format is the data in? You could probably create and schedule a DTS package to read and upload the data in the files.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[mrdenny]

Or Better yet, write a batch file which does the following.
1. Move the Data from the Telecom server to the SQL Server.
2. Using the dos command "FOR" load the data into the SQL Server using BCP
3. Delete the log files from the SQL Servers hard drive (or more them to another folder for archiving).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com