Task scheduling question

[Walid]

I want to query a data source (Not a SQL-Server) for all the records it has using its ODBC driver, then repeat the process every x amount of minutes to query the records that has been added since the last time and insert all the records I get every time in a SQL-Server database. The first idea came to my mind is to write a Windows service that will run in the back ground (Just because I like to mess up with that kind of programming), but I thought that SQL-Server may already has the ability to do that.


So the questions for you ladies and gentlemen, the SQL-Server Gurus, is; what is the best way to do it and what to watch for?

By the way, I have no write access to the source database and I can’t modify the structure of it to add or remove any fields.


Walid Magd
Engwam@Hotmail.com

 

[Catadmin]

Check DTS in Books Online. You can create a package that connects to your data source and schedule it to run every so many minutes/hours/days/weeks...

You will need read access on your data source, BTW, so if you don't have it or you don't have write access to the SQL database & drive share, then you're SOL.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"