BizTalk Adapter 3.0 for mySAP Business Suite with SSIS, how to specify result table? RRS feed

  • Question

  • hi there, i am using SSIS to import data from sap to sql server with BizTalk Adapter 3.0 for mySAP Business Suite.
    I can import data with SELECT query, but I can't import with RFC/BAPI functions.Please help!

    In SAP, there is a customized BAPI (ZBAPI_ABC_GETLIST) , no import, one export(RETURN) and one table(TABLEA).
    In SSIS ADO.NET Source for mySAP, i execute "exec ZBAPI_ABC_GETLIST OPTION 'disabledatavalidation' ",
    but SSIS get RETURN as result, but i want to get TABLEA as result.
    Please tell me how to write correct syntax.

    thanks in advanced.

    Tuesday, August 28, 2012 2:30 AM