theq Freshman


Joined: Jan 18, 2005 Posts: 4
|
Posted: Wed Jan 19, 2005 5:03 am Post subject: Text to SQL |
|
|
On one server we have text files that are created showing a streamline of events occuring. For each file contains a full days of events, each line representing a new event.
What I am been trying to figure out is how to get this information pulled into a SQL Database on an automated basis.
Example: Every 5 minutes, the script would run pulling any 'new' events from the file. Once a new file is created and all the events from the previous file has been copied into the database, then it would continue to collect the 'new' events from the new file. This process would continue indefinately.
Since there is no FTP access, I am not sure if SQL can accomplish this task alone...
Suggestions? |
|