From Oracle to SQL 2000

[pflakes]

I'm currently working on a project where I'm running a procedure on an Oracle database and then need to insert the results into a MS SQL 2000 database.

I've asked the DBA's to help out but they've never dealt with this either and it's really dragging my project down.

If anyone has any examples I could pass on to them it would be a great help!

Thanks in advance.

 

[dbtoo2001]

http://www.microsoft.com/technet/tr...echnol/sql/maintain/featusability/dataimp.asp

 

[pflakes]

dbtoo2001 --

The problem with this solution is that the procedure running on the Oracle database doesn't write the data to a table I could import from. I need to insert into the SQL 2000 database as the Oracle procedure runs.

I'm guessing there is something on the Oracle server that needs to be setup for the transfer to work run-time?

 

[dbtoo2001]

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c01_02intro.htm#48110