December 2, 2014 at 8:13 am
In my project Using SSIS to connect the SAP BW 7.31 objects.
Goal is, I need to raise the request from SSIS to fill the SAP OHS (tables ) and pull the data to my SQL server databases .
I am using SAP BI connector 1.1 . SQL version - SQL Server 2008 R2 SP3 .
In SSIS using BI source connection and able to pull the data successfully from SAP OHS (tables) through Process Chain method .
I deployed the package and able to run though SQL Agent too .
Requirement is to create a separate SSIS package for pull the data from 10 different OHs(tables) in SAP BW .
The problem is, when I am trying to run these ssis packages parallel , none of the package are running successfully and getting timeout error .
I increased the time out to max but couldn’t help .
I created a job for each package and ran parallely .
While checking this in debugging mode , all packages are getting stuck up with the “Wait for notification state”.
-I have tried this using SAP BI OLEDB Connection in single application server mode as well as Load balancing server mode.
In both mode I am not able to run the packages parallel .
Please let me know , how we can fix it ?
Thanks in advance - Gopal
March 18, 2015 at 6:59 am
Our experience is that we can have no more than 3 SSIS packages pulling BW data at the same time. There is no rhyme or reason to it. Have tried tweaking various things on both the SSIS and BW sides and it made no difference.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply