Skip to Content
0

SAP Open Hub connect SQL with SSIS

Jun 06, 2017 at 03:51 AM

67

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mallikarjuna Gande Jun 06, 2017 at 04:18 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0