RE: batch updates with ASP

by "Todd Philipps" <todd(at)anvil-group.com>

 Date:  Fri, 18 Aug 2000 06:50:33 -0700
 To:  "'Andrew Browne'" <andrew(at)pbm.co.za>,
<hwg-languages(at)hwg.org>
 In-Reply-To:  ANDREW
  todo: View Thread, Original
Check into Data Transformation Services (DTS) available in SQL Server 7.0
It should be able to do what you want.  You can write a job to pull the the
needed rows from Oracle and inserting them into the SQL database.

Todd Philipps
the Anvil Group


-----Original Message-----
From: owner-hwg-languages(at)hwg.org [mailto:owner-hwg-languages(at)hwg.org]On
Behalf Of Andrew Browne
Sent: Friday, August 18, 2000 3:20 AM
To: 'hwg-languages(at)hwg.org'
Subject: batch updates with ASP


Hi all

I hope this question is not off topic...

I have a project to design "something" to grab drug records from an Oracle
database, dump them in a SQL Server database and clean them up.  These 2
databases don't interact with each other at all, so I thought to use Access
to run a number of pass-through queries between the databases.  However, for
some reason it balks when using ODBC to connect to Oracle despite the fact
that the DSN works properly when tested.

So, I'm now testing the less efficient method of using an ASP page to dump
the Oracle resultset (24000 records!) into an array using  RS.GetRows().
However, in order to update the SQL Server, I need to double-loop through
the array, building a querystring and executing. I reset the querystring and
begin the second loop etc. etc. I know that ASP was not designed with this
sort of batch-processing in mind but, being an foolishly optimistic person,
I am wondering if anyone working with ASP has any knowledge of a means of
sending the entire Oracle recordset to a SQL Server procedure in one single
execution and then have the database perform its insert.
_____________
Andrew Browne
IT
658-6484
_____________

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA