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 |
|
pmk.sunil
Starting Member
2 Posts |
 Posted - 2011-11-01 : 04:14:14
|
| Hi...I am using SAP BI componet in SSIS to import the data from SAP and store the data in SQL Server. It works fine when i gave the values of SAP BI component statically. Now i want to give SAP BI Componet values from .NET. Can any body help how to give the values dynamically to SAP BI Component. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-01 : 04:49:13
|
| you can add a variable to hold the connection config details and then pass dynamic value through a configuration file while executing package. Other method is to pass variable value directly through dtexec utility while calling package.Inside package you can map variable to datasource property of SAP component through expression builder------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to pass values dynamically to SSIS Packgae