Strange behavior with uri and WebClient lessons in SSIS package

I have a rather strange situation.

I have this very simple package:

enter image description here

  • The "get list" task retrieves a data table from an assembly with a single column and a list of URLs that will be launched into the object variable.
  • The foreach loop goes through the object variable and loads the url in the url string variable
  • "Run" invokes the url with this code (its 2005, so I'm stuck with VB):

    Dim myURI As New Uri("http://" + Dts.Variables("URL").Value.ToString())
    Dim myWebClient As New System.Net.WebClient
    myWebClient.OpenReadAsync(myURI)
    

the called URL is internal and just reads the parameters and performs a series of operations that take some time, so I used "OpenReadAsync"

: 4 URL- , 2 . lops 4 , script 4 ( , ), myWebClient.OpenReadAsync(myURI) 4 4 , 2 URL.

, 2 URL-, , URL- . 4 URL- (, 4 ) , , , , URL-.

, VB, , uri WebClient, , Im - . 5 , .

.

+5
2

, , ..NET 2 . , .

, script, , Dispose WebClient. WebClient , , . , .

, OpenReadAsync , , . DownloadXXXAsync, .

DownloadStringAsync DownloadStringAsyncCompleted.

UPDATE:

ServicePointManager.DefaultConnectionLimit , , - AppDomain. SSIS AppDomain , .

, FindServicePoint, ServicePoint :

var myTarget= ServicePointManager.FindServicePoint(new Uri("http://www.google.com"));
myTarget.ConnectionLimit = 10;
+4
  • .

  • , ​​ SSIS. SSIS ETL, !

+1

All Articles