SSIS Error : Code: 0xC0047062 + Its solution
Hi All we need to get files from Https location and then extract and load . For this we are using Script transformation AS SOURCE . As the file need some string operations to get columns we used Script transformation in that we used Httpwebrequest to connect to that URL by passing username and password . The package works fine from BIDS in my local machine but when we deployed in dev server and created SQL job the job is getting failed at HTTP url connection level . with the fallowing error Code: 0xC0047062 Source: get chat file list get files [1] Description: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it Code: 0xC0047038 Source: get chat file list SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "get files" (1) returned error code 0x80131509. To Solve th