Skip to Content
avatar image
Former Member

SAP Open Hub connect SQL with SSIS

Hi All,

I have create data integration package to extract data from SAP BI Open Hub to SQL Database which it working fine when I execute it directly in Microsoft Visual Studio.

However, When I try to run it via DTEXEC command or via SQL Server Agent it show error as below

Source : Data Flow Task SSIS.Pipeline

Description: The SAP BW Source cannot run on the installed edition of Integration Service. It requires SQL Enterprise Edition or higher.

So, I didn't sure that it really need a license ? due to it can be run directly via MS Visual Studio. If anyone have experience on this, Please let me know.

Million thanks.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 06, 2017 at 04:18 AM

    Hi,

    SAP BI Open Hub to SQL Database which it working fine when I execute it directly in Microsoft Visual Studio - Is it manual execution from Studio? and which version of Visual studio you are working with?

    Btw, To automate extraction, using third party tool via Open hub required addtional licence.

    -

    Regards,

    Mgande

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      My visual studio version is 2012 + SQL 2012 standard and yes i run package manually in visual studtio.

      For additional license is SAP license or SQL License (Enterprise) ? Thanks for the answer.