I would like to load data from SQL server to SAP BW using SSIS.
Could someone help me on it, how can I do it?
Currently I am using SQL Server 2005.
asked Jun 4, 2013 at 5:44
-
You're asking a very broad question, can you be more precise? What have you tried so far and where are you stuck? What errors or other issues do you have?– PondlifeCommented Jun 4, 2013 at 19:16
-
Yeah, Actually i need to load the data from sql server database to SAP BW Using SSIS. For that i would like to create a SSIS Package. Source: SQL Server(OLEDB Source) Destination: SAP BW– Sandeep PulikondaCommented Jun 5, 2013 at 5:55
-
1You seem to be asking "how do I create an SSIS package?", which is not something that can be answered in a short, definite way. I suggest you review the documentation and look for some tutorials, then just start building your package and see what happens. If you get stuck and have specific, answerable problems then of course you can post them here.– PondlifeCommented Jun 5, 2013 at 15:14
-
Can you please suggest me any links?– Sandeep PulikondaCommented Jun 7, 2013 at 5:03
-
And Where can download the Data Provider for SAP (SQL Server 2005)– Sandeep PulikondaCommented Jun 7, 2013 at 9:15
|
Show 3 more comments
1 Answer
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.
