I am having an issue with SharePoint List Source.
Task at Hand:
Import a Sharepoint List Source to SQL Database
I am having an issue around a proxy error however i have got this working but only on my local account it will not work on the server login which i need it to, to be able to schedule the task to complete automatically
Windows Domain environment
Local PC: XP running VS 2008 and SQL Server 2008 R2 both connecting into the server
Server: Server 2008 R2 (VMWare) running VS 2008 and SQL Server 2008 R2
I setup the sharepoint list source on the server (using a server login) to export to a database and intially couldnt even get the columns to show up. After much searching i found adding some code to the VS devenv.exe to reference the local proxies got round
this. However when i ran the package in debug it doesnt work and gives a 407 proxy error.
I setup the same package on my local pc logged in as me and the package ran fine first time
i logged in under the server login on my local machine and same issue as on the server.
Both logins have exactly the same access levels to the sharepoint site in question
Both Local Machine and server are on the same domain.
Can anyone shed any light on why i would be getting proxy errors under one login but not under the other?