How can I automate some processes in SQL Server Express?

I need to automate SQL Server Express 2008.  Basically I need to import 4 text files, and then run some pretty simple SQL on the tables that I’ll build.  I’m wondering what is the best way to do that . . .
 
Should I use some batch processes, fired by Windows Scheduler?  Should I use Triggers to do this?  I’ve never used Triggers before; I don’t even know the first thing about it.
 
Thanks everyone!!
Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.