Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunil.pathaneni
Starting Member
1 Post |
 Posted - 2011-11-07 : 03:59:38
|
| Use of SAP BI Source Component:By using SAP BI Source component we can extract the data from SAP and store the data in the desired destination.Adding SAP BI Source:The SAP BI Component will not show at your Toolbox in SSIS Package. To get the SAP BI Source component in your SSIS package you need to install “Microsoft SAP BI” exe in your computer. After install this to add the SAP BI Source component, we have to do the following steps:? Open toolbox in SSIS package ? Right click on Data flow Source tab, select choose Items? In the Choose toolbox items, Click on SSIS Dataflow Items ? Select the SAP BI Source component and click on OK.When we click on SAP BI Component a window will open and here we can enter the details to extract the data from SAP: It will be run successfully when I gave the values for SAP BI Component statically. Now I want to pass the values dynamically to SAP BI Component from .NET. To do this we have to create the Variables in SSIS package and those variables should be given in the properties of a component.The below screenshot shows the variables which I have created Here the problem is these steps are not working with SAP BI component. The same steps I applied for OLEDB Source component in a SSIS package. It works fine. Because it has the option for accessing data from variables. If we find this type of option in the SAP BI Component, we can easily access the data from the variables. So, we hang here how to pass the variable values to component properties. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-07 : 04:24:06
|
| first of all we cant see the screenshotdid you try writing values to a table from SAP BI component and then use package configuration in ssis package to get values of variables from the table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to pass values dynamically to SSIS Packgae