Were you able to fix your issue?

I ran into a similar issue and if you were able to fix yours, please let me know how you fixed it.

I have created an SSIS package that uses HTTP connection manager and script task to download the file from a website and save it to the local disk. The package works great on windows server 2008 but fails with the following error message on windows server 2008 R2.

[Void DownloadFile(System.String, Boolean)] Error: Exception from HRESULT: 0xC001600D

[Connection manager "HTTP Connection Manager"] Error: Request cannot be processed. Try again later.

Here is sample code in the script task:

Public Sub Main()

Dim httpConnection As Microsoft.SqlServer.Dts.Runtime.HttpClientConnection

Dim c As Object

c = Dts.Connections("x").AcquireConnection(Nothing)

httpConnection = New HttpClientConnection(c)

httpConnection.DownloadFile(Dts.Variables("fileloc").Value.ToString(), True)

Dts.TaskResult = Dts.Results.Success

End Sub

I checked the firewall settings and cannot figure out what is blocking the download. I don't think there is any issue in the package as it runs fine on 2008 but fails on 2008 R2. Please help!

Thanks in advance.