I am creating an SSIS package in visual studio 2005 to do a fairly simple web service task via a script component transform (problems with the web service built in task made me build this as a script component) and I am having problems with it failing due to:
"Error: 0x1 at Data Flow Task, FetchRates: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. )."
On my http connection manager that i'm using, i have the server URL as the full HTTP url to the WSDL file, and my proxy url as set to "http://proxy.myserver.com:8080
" and all the correct username/password/domain info supplied. I know this is correct because i used this same proxy info to create the VB wrapper of the WSDL file that i needed for the script component. Are there any known bugs with VS2005 for the HTTP connection manager??
Also, as a final side note i have tried every variation of the above i can think of (i.e. removing the "http://
", removing the ":8080", etc). Also, i can get the "test connection" button to test successfully.
I really appreciate any help that can be given. I've been banging my head on this one for a while!