I have SSIS package which selects certain records from SQL server table, then calls Web service (web service is wrapped into DLL), sends parameters from selected records and populates anothertable with the data brought from SAP by Web service. Call to the web service's methodresides inside the loop. I noticed only 100 records can be processed, after that connection to SAP is being destroyed and i have to re-start application pool in order to enable web service again. The same web service brings data from SQL server. this connection remains ok.
Does anyone know why web services corrupt or why SAP connection is destroyed?

Something like:

rd = GetDataReaderStoredProc(

"spTest")
If Not rd Is Nothing Then
While rd.Read()
....
dsCompany = oSAP.getSAP_FinancialCompany_Data(rd("Order_Num").ToString) 'calling web service
....
dsCompany = Nothing
End While
rd.Close()
rd = Nothing
End If

Are you using ASMX web services or WCF?
What is SAP?
Is there any type of exception being thrown when the SAP connection is destroyed?

If you do not have tracing enabled you may want to do so, so that you can better see what is going on with your service.

Thanks,
Erica

---

Erica Mohler - MSFT