Oracle --> SQL DTS issue

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all,
I am accessing a Oracle Database for DTS using MS ODBC driver.
The simple queries can easily provide the data required over the DTS,
however i am unable to access certain queries which have been written
using Cursors (utl_file.put_line) where the Query is designed to
provide the output into a text file.

These queries are legacy and have been running as such for several
years , till date they have been imported into Excel and worked on.
however with 65k limit (excel) being breached I am being asked to set
this up as an DTS.


We have minimal (query only) access to the oracle Db and it is not
possible for us to use anything like a temp /staging table to output
the info.


I really wish to avoid getting major chunks of data over to the SQL
system and carry out manipulations there as the SQL system is running
on very low end HW (1 cpu 256 mb P3 someone old desktop actually)


I have no knowlegde of oracle and am stumped.


Any suggestions on how to handle this would be extremely helpful. I am
looking at some method of replacing utl_file.put_line in some fashion
so that I can get the output recognised by SQL server.

I hope someone has faced this kind of problem before.


Thanks & Regards,
Abhishek

.

Relevant Pages

  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: Inserting 20 Million Rows to Oracle
    ... I would be inclined to throw the rows to flat file on disk, FTP the file across, and use SQL*Loader to do the import. ... You have to DTS 20 million rows nightly from SQL 2000 to Oracle 9.2.0. ...
    (microsoft.public.sqlserver.dts)
  • Inserting 20 Million Rows to Oracle
    ... You have to DTS 20 million rows nightly from SQL 2000 to Oracle 9.2.0. ... SQL Server DTS write .csv file, FTP to oracle box, sqlloader, ...
    (microsoft.public.sqlserver.dts)
  • Re: Ansi SQL to JET SQL
    ... With a pass-through query, the host database (Oracle in your case) executes ... Pass-through queries are not-updatable in Access, though, in case ... > know of a program which converts SQL into JET SQL? ...
    (microsoft.public.access.queries)