[dba-SQLServer] Data from Oracle to SQL Server

I am not that knowledgeable in SQL SERVER. Will become more so in the
next few months but need some help now. Thanks in advance for any help.

We have a large database in ORACLE. From this is generated a monthly
summary report that does contain calculated fields.  They have now
decided they want to create a table on an MS SQL SERVER database that
contains/matches the data in this report.

One person wants to have a special view created on the Oracle DB for
each month so that they can use an MS SQL Server WIZARD to extract this
data to Sql server. The last thing I want is to have to use a WIZARD
every month or have one non-IT person responsible to run this wizard
every month. I prefer to have things like this in a PRODUCTION ROUTINE
type mode. Either a proc or sql query/make table query that can be
scheduled to run.  

One person says they can't run a query that has calculated fields to
make a table in SQL server.  I know in ORACLE I can make a table using
query and subqueries containing pretty much any type field including
calculated fields.  Can't this also be done from a SQL SERVER database.
Granted the original data is located in another database. 

Can you send me an example on how to set this up or where to look.   

Patti
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.otda.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.