locked
An OLEDB ERROR with Stored Proc RRS feed

  • Question

  • Error at Data Handover Average Delay Group [Calc Handover Average Delay Group [19]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Procedure or function 'AEM_W_HandoverDelayGroup' expects parameter '@WE', which was not supplied.".

    Error at Data Handover Average Delay Group [Calc Handover Average Delay Group [19]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available. Please help.....ASAP

    Monday, June 24, 2013 9:21 AM

Answers

  • It must be a poorly formatted expression to call a stored procedure. Namely, parameter @WE value not supplied.

    Arthur My Blog

    • Proposed as answer by Akhila Vasishta Monday, June 24, 2013 3:56 PM
    • Marked as answer by Mike Yin Saturday, June 29, 2013 9:24 AM
    Monday, June 24, 2013 3:04 PM