Load storedprocedure with parameter into datastage

[sqlskrathan]

Hi,
I am working on Ascential Datastage with SQL Server 2000 I have problem with a stored procedure.

I am trying to use a Stored Procedure into my ODBC Stage and pass one "job parameter" value into the stored procedure but, It gives below error
"Error: The name must begin with an alphabeticcharacter and consist of alpha-numerics,underscores, and periods only."

Shashi

 

[MDXer]

You might have better luck in the Ascetial forum forum357. This forum is for Microsoft Analysis Services.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck