SSIS Batch Geocoder Error

Jan 3, 2013 at 5:28 AM
Edited Jan 3, 2013 at 5:29 AM


I am trying to run the example example dtsx package and I am getting the following error. Can anyone please help me on this?

I have used the Trial Key for Business Asset Management for Bing Maps Key.

The error:

[Geocode From Fields [331]] Error: System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.
   at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
   at System.Net.HttpWebRequest.GetRequestStream()
   at SSISBatchGeocoder.Geocoder.ExecuteBingGeocodeFlow()
   at SSISBatchGeocoder.Geocoder.ExecuteBatch()
   at SSISBatchGeocoder.GeocoderTransformation.FlushCurrentBatch()
   at SSISBatchGeocoder.GeocoderTransformation.ProcessInput(Int32 inputID, PipelineBuffer buffer)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)


[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Geocode From Fields" (331) failed with error code 0x80131509 while processing input "Input" (333). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.