SSIS 2008 - Microsoft BI connector 1.1 issue in parrarell processing

• pgk1983

  Grasshopper

  Points: 20

  More actions

  December 3, 2014 at 4:41 am

  #312833

  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