DSXchange

How do I execute stored procedures on conditions in Server Job , ODBC stage? If statements are giving me errors.

You can't. Split the flow and only send the ones needing the SP call down one branch, all others down another. Join the stream back together after that. That or call it each time and conditionally use the result. Of course, that depends on what exactly it is your SP is doing.

Another option - code the SP itself to be conditional. Always call it but pass it an argument so it knows whether it should 'execute' itself or not.

Actually, I was able to use the IF statement. There was a syntax error, which was causing the job to fail . Thanks!

Really? Huh, learned something new. Perhaps an "ODBC thing"... could you post the syntax you used for me, please?

are u mentioning anonymous blocks here