The SSIS default connection manager is not connected to Oracle or SAPBI, so you can use the Connection Manager plug-in provided by Microsoft if you want SSIS to invoke the SAP RFC.
For more information on this point, refer to the official MSDN documentation:
Http://technet.microsoft.com/en-us/library/ms140203.aspx
The specific Connection manager address can be:
http://www.microsoft.com/zh-cn/download/details.aspx?id=16978
Download to.
After downloading and completing the installation, you can see in SSIS that the Connection Manager contains SAP BI, as shown in Figure 1.
Figure 1. SSIS containing the SAPBI Connection Manager
It is noteworthy that if SQL Server is an evaluation version, the installation of Connection Manager may not be installed because the prerequisites are not met.
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/