SSIS HttpClientConnection failed to download file via HTTP Connection ManagerFriday, June 15, 2018 / mcchu28
Dim nativeObject As Object = Dts.Connections("HTTP Connection Manager").AcquireConnection(Nothing)
' Create a new HTTP client connection
Dim connection As New HttpClientConnection(nativeObject)
You many see this error when you debug the connection.DownloadFIle:
Exception from HRESULT: 0xC0016008
Right click the HTTP Connection Manager and choose edit.
Check Use credentials and click OK. Then edit again, this time uncheck Use credentials.
Behind the scene, there is a default password that is used. For some reason this causes the issue.
If you have source control, you can actually see the file may have changed the encrypted password on the HTTP Connection Manager.
This seems to fix my issue.