Call oracle stored procedure with output refcursor from ssis

• waralees

  SSC Eights!

  Points: 862

  More actions

  September 7, 2011 at 6:40 pm

  #149585

  Dear All,

  I want to call oracle stored procedure with output refcursor and pass parameter to store procedure from ssis via execute sql task.

  How can I set it??

  Thanks,

  All

• Ken

  SSCoach

  Points: 17191

  More actions

  December 6, 2011 at 12:05 pm

  #1417600

  check out this post to see if this solution would work for you:

  http://www.sqlservercentral.com/Forums/Topic649363-148-1.aspx#bm978699

  I am currently in a similar bind and this is the best solution I have run across so far.