SSIS Execute SQL Task - Execute Oracle Stored Procedure

• sackmeister

  SSChasing Mays

  Points: 607

  More actions

  January 24, 2011 at 2:28 pm

  #233862

  Hi All,

  I have an SSIS Package I'm building. I've created a connection to my development Oracle database and can execute queries against it. I've added an Execute SQL Task to execute an Oracle Stored Procedure that does not require Input or Output parameters, and therefore I setup the tasks ResultSet to None. When I run the Execute SQL task, I get the following warning messages:

  Warning: Multiple-step OLE DB operation generated errors.

  Check each OLE DB status value, if available.

  No work was done.

  The SQLStatement in the task is as follows:

  BEGIN

  LOAD_ADP_HIERARCHY;

  END;

  When I check on the Oracle side, I can tell the SP ran without error. Can anyone tell me if there is a way to suppress this warning, or if there is something I can do differently to eliminate it?

  Thanks in advance!

• David R. K. DeLoveh

  Valued Member

  Points: 61

  More actions

  February 18, 2011 at 3:09 pm

  #1289096

  I have seen similar behavior and resolved by using an ADO.NET connection instead and calling the procedure like this:

  CALL LOAD_ADP_HIERARCHY()

  Note: I leave the IsStoredProcedure property set to False.