December 3, 2014 at 4:41 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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply