Dear Experts,

I would like to insert a result set from the SQL server
2000 Stored procedure to Oracle 9i database.

I am thinking to create txt file out of result set, but I
am not sure How can I create a txt file directly from
stored procedure?

Anybody has a better Idea?

TIA
..

You have a few options including DTS, bcp, osql.
You just need to execute the stored procedure to send the
results to a text file. For example, for osql it's just
something like:
osql -SYourServer -E -Q"exec
YourDatabase.dbo.YourStoredProcedure" -oC:\TestOut.txt

You can find more information on all of these utilities in
books online. Bcp has an example of exporting a query to a
text file - just change this to execute your stored
procedure. In DTS you can use a transform data task to
execute the stored procedure in the SQL Query window and use
a text file destination.

-Sue

On Thu, 20 Nov 2003 17:55:35 -0800, "Sandeep"
[quoted text, click to view]