CODEWITHSUNDEEP
sqlssisbidssap-bw
Ml Ck
Ml Ck

Reputation: 37

SSIS 2014 integrate SAP BW, MS Connector 1.1

I'm trying to setup the integration between SQL Server 2014 and SAP BW 7.3. I read a white paper but it was talking about SQL 2008 and MS Connector 1.0.

I'm using SSIS 2014 on VS 2012 with MS Connector 1.1 librfc32.dll is in system 32 folder.

When I'm trying to create a new connection on the Integration Services Project I can't find "SAP BW Source" nor I can find SAPBI connection in the new connection option!

As I've seen it should be between "OLEDB" and "SMOServer" and should say "SAPBI":

New Connection Manager Options

I have selected the SAP BW Components from the .NET Framework Components:

.NET Components

Also there's no "BW Source" as it should have in the source list of the SSIS Toolbox:

source list of the SSIS Toolbox

Please help! I'm lost, thanks.

Upvotes: 2

Views: 831

Answers (1)

Ml Ck
Ml Ck

Reputation: 37

For anyone having the same problem, a simple solution:

With SSIS 2014 VS 2013 needs to be used.

Upvotes: 0

Related Questions