Automating Query

I am looking for the best method of automating an INSERT query in SQL Server 2005

Code:
--------------------------------------------------------------------------------

'INSERT INTO SaltInvWhOpen (StockCode, Warehouse, TrnMonth, TrnYear, OpenBalQty, OpenBalCost)SELECT StockCode, Warehouse, Month(GETDATE()) AS TrnMonth, YEAR(GETDATE()) AS TrnYear, OpenBalQty12, OpenBalQty12 * UnitCost AS Expr1FROM InvWarehouse
--------------------------------------------------------------------------------


In older versions I would have used a DTS package (It's been a long time and I'd have had to use a book to guide me through it), but as that is gone now, I am unsure where to even begin looking.

If someone could assist by giving me the current method, and dare I ask, walk me through it, the help would be much appreciated.

Thank you!

Julia