SQL Server Newbie Question - Ian Gendreau

I am a total SQL Server noob.  I've gone about as far as creating a
new database and creating my fields.  I have done extensive
programming in MS Access, but I need to do this in SQL Server.

Basically, I have an ODBC connection to an Oracle database that
resides at an ASP.  There are a dozen tables or so that I need to
download nightly.  I don't need to do any uploading, just once a
night, download any new records and any records that have changed at
all.  Using SQL Server 2005 by the way.

Don't even know where to start looking for tutorials or guides to
begin.  Hopefully someone can point me in the right direction to get
started.  Thanks!

SQL Server Newbie Question - Stuart Ainsworth

There's a couple of different ways to do it, and I'll try to give you
enough keywords to help you do a search in either Books Online or good
ol google.

1.  Create a linked server to the Oracle database, and build a stored
procedure (or set of procedures) to pull the data from the source
database to the target database.  You can then use SQL Server Agent to
schedule a nightly job.

2.  Use SQL Server Integration Services to build a package to pull
over the data, and use SQL Server Agent to schedule and run a job.

Hopefully, that'll point you in the right direction.