How to load data from SQL Server to SAP BW using S

Question

I would like to load data from SQL server to SAP BW using SSIS. Could some one help me on it how can i do it. Currently i am using sql server 2005.

Answer 1

Why would you use SSIS for that? I would recommend either load using SAP BW standard anyDB source system or using BO Data Services. Both do it natively and well. If you insist, look at: https://theobald-software.com/en/xtract-is-productinfo.html They have the following feature:

Xtract IS BW Loader

With the Xtract IS BW Loader data target, you can reroute data streams within your SSIS data flow directly in your SAP BW system.

The corresponding BW InfoPackage is automatically triggered and filled in. Of course, the component is based exclusively on the required SAP standard (staging BAPIs for third-party vendors). The following screenshot shows how the pipeline elements can be linked within the Integration Services with the transfer structure.