Hello, i have downloaded and installed SharePoint Source and destionation adpater from codeplex http://sqlsrvintegrationsrv.codeplex.com/ on my development pc I can create an ssis package with a workflow with a source from my sharepoint server (this is a server, not on my own development machine) the design of the SharePoint List Source works: I can define a sharepoint list, it will show me the proper columns, but when i want to run the package it gives an error: "The remote server returned an unexpected response: (407) Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ). ---> System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required." I cannot see any proxy user and proxy password that I can supply; Does that mean that the SharePoint source and destination adapter can only run on the same machine as the sharepoint services? Or what can I do to solve this?Jan D'Hondt - Database and .NET development

How are you running the package on your development PC?using BIDS? dtexec on the commandline? or as a SQLAgent job?Thanks.

As this thread has been quiet for a while we will be changing the issue type to General Discussion'. If you wish to return to this question you can go ahead and change the type back to Question. Then you can edit your initial post and change the radio button at the top of the post editor window. If the issue has been resolved, wed love to hear your solution. By sharing your experience you can help other community members facing similar problems. Thanks! Yao Jie Tang -Microsoft Online Community

If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components: * SharePoint Source SSIS Data Flow Component * SharePoint Destination SSIS Data Flow Component * SharePoint SSIS Connection Manager Batch insert and update is also supported. Also the connection manager supports specifying of proxy name and password credentials. SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi, I was able to fix the 407 webpart error by simply installing the ISA-client on the sharepoint server, configuring it and apply default + browser settings from it. Hope it helps!