Sharepoint List Source returns 0 rows

Jul 14, 2009 at 6:19 AM

Dear Experts,

I'm using SSIS for the first time with your Sharepoint list source component. My case is that I'm working very fine on my development server http://bhk54/bhk/ims/ and once switched to http://bhk77/bhk/ims/ it returns 0 rows. Both sites are in same structure.

Would you suggest any possibility to check with?

 

Result captured by HTTP debugging proxy:

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/"><GetListItemsResult><listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
     xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
     xmlns:rs='urn:schemas-microsoft-com:rowset'
     xmlns:z='#RowsetSchema'>
<rs:data ItemCount="0">
</rs:data>
</listitems></GetListItemsResult></GetListItemsResponse></soap:Body></soap:Envelope>

Sep 29, 2009 at 6:15 AM

Check the account that you're using to access the new site and make sure it can read the rows you need. SP Security is still in effect, so it needs to be able to see the rows.