DTS Import

[DebbieChapman]

Every day I have a file posted into a specific directory which I then manually import into an SQL table.
I'm trying to work out a way to schedule this to be done automatically. I know I can set up a DTS package to import the file, but what I am trying to get my head around is getting SQL (7) to look to see if the file is in a specific location (the file format is: dailyimports_ddmmyy.csv) if it is import it. and then if it has been imported rename it (ie dailyimport_ddmmyy.archive). can this be done, or am I just asking for the moon.

I would be grateful if anyone can give me some pointers.

 

[JohnDTampaBay]

Here's a thread with a similar request. Its a little involved, but definitely do-able. Good luck!

thread962-556192

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.