This is probably a real silly question, but since I have not found it in a FAQ or any where in discussion, I'll ask it here.
After installing the SharePoint List Source and Destination msi, I added the tools to the data aflow toolbox, dragged a SharePoint List Source object onto the design surface and opened the Advanced Editor.
I added a SiteUrl and SiteListName, leaving the SiteListViewName blank, and I get an "Error at Data Flow Task [SharePoint List Source]
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unhandled SharePoint Exception ----> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
I think I'm using the correct syntax for the SiteUrl and SiteListName values.... namely SiteUrl is
http://sitename/ and the list name is relative "/collaborate/listname"
any clues gratefully recieved..