Seth,

You might find the data easier to work with if you use DTS to import the tables unchanged from Oracle into a SQL Server 'staging' database then transform the data...

Here are some sources of DTS information if you decide to investigate John's suggestion further.

Executing DTS from ASP: see http://www.sqldts.com/default.aspx?207

Control access to DTS packages with owner and user passwords....

Check out "How to set up, maintain, and bring online a standby server" in BOL.  Basically, you have to perform a full backup of Database A, restore Database B with...

If, by username, you mean the owners of the packages, you can SELECT OWNER FROM MSDB.DBO.SYSDTSPACKAGES.

There is no way to retrieve the owner password.

Greg

This may not be much help, but it's the only article that came up when searching Microsoft's KnowledgeBase:

http://support.microsoft.com/default.aspx?scid=kb;en-us;268481&Product=sql2k

Greg

A full database backup doesn't truncate the inactive portion of the log.  That occurs after the log backup.  That's why the log is still contains the entries for the reindex after...

Check out this description of "High Availability":

http://www.microsoft.com/sql/evaluation/features/reliable.asp

Greg

Yes.  Just put the steps for each file into a single package using DTS Designer.

Provide more details for more detailed advice.

Greg

Have you thought of using views to exclude the columns you don't want them to see?

Greg

Take Steve's advice and put all of your table building code into a stored procedure or a batch file and execute it in one job step.

Greg

Creating constraints is not the default.  I'm assuming you want DTS to create the table before importing.  If you use the DTS Import/Export Wizard and choose "copy objects and data...

You don't get error logging when using the wizard.  Try Running the wizard again, but this time save the package.  Open the package in DTS Designer and enable package logging...

Check this KnowledgeBase article and see if it applies to you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;814113&Product=sql2k

It includes a patch. 

Greg

You say that you are dbo of both databases, but does the login that SQL Server Agent runs as have permissions in the VFP database?  Scheduled jobs run in the...

1. Yes, the latest version will always be executed.  The package GUID remains the same regardless of how many versions are saved.

2. Correct. 

3. Right again.  A new version GUID is...