Post reply

How to call Oracle stored procedure from SSIS package

  • February 15, 2007 at 7:09 am

    #116212

    Hi, wondering how to call/run an Oracle stored procedure from an SSIS package

  • February 21, 2007 at 3:33 am

    #690848

    Hi,

    I am also trying to do this. I created a package with only execute sql task, and ran the sql command as EXEC ProcedureName.

     

    The issue here is, this run fine on Sql Server, but fails on Oracle saying that it is an invalid sql command.

    Any suggestion on this?

     

    Thanks,

    Manish

     

  • February 21, 2007 at 4:56 am

    #690856

    Mark,

    I got the procedure thing working on Oracle as well as Sql SErver. WHat we wanted to do was run a stored procedure which will update the target table both on oracle and sql server.

    So, we created a package with execute SQL task, and used the {call storedprocedurename()}

    This works for both, oracle and sqlserver. Previously I was using exec storedprocedurename, but it fails on oracle with message invalid sql statement, but runs fine on SQL Server.

     

    Hope this helps!!!

     

    Manish

     

     

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply