| abhishek 2005-05-24, 3:23 am |
| 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
|