Data Source Integration Server

• erickegea

  SSC Enthusiast

  Points: 174

  More actions

  December 6, 2018 at 4:13 am

  #369350

  Hello Guys,

  I am trying to configure a data source on integration service to connect on a SAP Hana database.

  I installed the Hana Driver and set the Data Source: SAP HANA MDX Provider. I tested the connection and IT's OK.

  However when I try to select something trough a OLE DB Source, I have a error:

  TITLE: Microsoft Visual Studio
  ------------------------------

  Error at Hana [Connection manager "Ue2"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
  An OLE DB record is available. Source: "SAPNewDBMDXProvider.1" Hresult: 0x80040E4D Description: "Connection to database failed.error while parsing protocol".

  Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Ue2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

  Do you know if I set something wrong?

  Thanks,

  Erick