DSXchange

Hi!

My source is SQL Server!

I need to work with a result set from a SQL Server's stored procedure in DataStage and after input the data into a Oracle.

Is there any stage that work with a stored procedure result set?

In the version 7.5 there is a "stored procedure stage" that work with Oracle, DB2 and Sybase but don't work with SQL Server.

By internal rules I can't read the SQL Server directly.

Regards

Fernando

ODBC stage, toggle SQL choice to stored procedure.

Thanks!

fmartinsferreira wrote:My source is SQL Server!

Why are you surprised?

ray.wurlod wrote: Why are you surprised? ...

Because it is the first time that I have SQL Server as a source.

Fernando