I am a newbie to sql server and would like some howto regarding the
best method to approach my problem. I have been developing with PHP
for the past year and dont really know how to do this under a windows
environment.

I am setting up a central database that is a collection about 20 db's.
Each night, the data (dbase IV) is uploaded to the central server and
imported into the central db. The fields that are to be imported may
change on a daily basis so I have info tables for each table which
contain the fields that need to be imported (so the query is dynamic).

I need to schedule this everynight and use dts (I assume) to import
the data. I was going to use ActiveX VBscript to do this but I find
the debugging capabilities quite limited within a dts package. Are
there ways to debug this code effectively?

Anyways to give more of an idea, here is the basic algorithm. It is
quite simple.

for each X {
open dbase IV connection
for each y in x {
build the query from the info table
import the data from the query into the central db
}
}

What I really need to know is what is the best method to do this and
have it scheduled. I am starting to miss PHP.

Thanx in advance for any advice,
Sean