Sharepoint list source returning no rows

Hi, I have 2 Sharepoint 2010 lists (actually surveys) with corresponding SSIS packages reading from them. Both used to work in Visual Studio, but not in SQL Agent Jobs, no matter what credentials ...

Id #21671 | Release: None | Updated: Jan 20 at 9:02 PM by gottfriededer | Created: Jan 20 at 9:02 PM by gottfriededer

Unable to see/ add component in Visual Studio 2013

Unable to see/ add component in Visual Studio 2013. Installed the component several times. Unable to add SharePoint list source and destination adapters. What am I missing? Other articles mentioned...

Id #21448 | Release: None | Updated: Thu at 1:19 PM by Rockie | Created: Oct 13, 2014 at 7:00 PM by Dkholo

Issue with scheduling my package (works fine outside of SQL agent)

I am using SQL 2012, with the 2012 adpator (installed on VM that i am building the package on where the server also resides). I've built my package in Visual Studio 2010, when i execute the package...

Id #21016 | Release: None | Updated: May 22, 2014 at 3:13 PM by stevelayton | Created: May 22, 2014 at 3:07 PM by stevelayton

ProtocolException in SharePoint List Source

Hi, I am trying the import ( and export too) data from a SharePoint Custom list. My site is running on Windows SharePoint Services 3.0 with SQL Server 2008. This site is using Form authentication ...

Id #20984 | Release: None | Updated: May 23, 2014 at 4:42 AM by WangYubo | Created: May 8, 2014 at 1:23 PM by maniishkumar

SSIS Sharepoint List adapter for SQL server 64 bit NOT working

Need a suggestions in MSBI 2005 and SharePoint 2007 front as one of our live application down with compatibility issues between SSIS SharePoint List Adapter for SQL server 2005 and SSIS 2005 T...

Id #20960 | Release: None | Updated: Apr 24, 2014 at 9:18 AM by Maaheswaran | Created: Apr 24, 2014 at 9:18 AM by Maaheswaran

Getting Issue while using "SharePointListAdapterSetup_x64"

Hi I have installed "SharePointListAdapterSetup_x64" on my machine and dragged "share point list source" under data flow task. I am getting below error when refreshing connection properties. Pleas...

Id #20957 | Release: None | Updated: Apr 23, 2014 at 2:49 PM by zubair25nov | Created: Apr 23, 2014 at 2:48 PM by zubair25nov

SharePoint Utility - RemoveFiles method and accentued list title

The problem with accentuated list title is that you can't get RootFolder from list name so current version of RemoveFiles method will not work. So, I made an updated version of RemoveFiles method ...

Id #20928 | Release: None | Updated: Apr 16, 2014 at 10:18 AM by cpassuel | Created: Apr 16, 2014 at 9:58 AM by cpassuel

examples installers can not be installed with sql server 2014

Could you please add msi installers for sql server 2014. I'v bought sql server 2014 developer edition and can not install the samples. Or instead of msi installers it would be better to have just V...

Id #20924 | Release: None | Updated: Feb 12 at 2:38 PM by SSISWizard | Created: Apr 15, 2014 at 7:41 AM by BBGONE

SharePoint List Source failed the post-execute phase

I'm getting a really vague error on one of my SSIS packages. It runs well in Visual Studio 2012, it runs as a package on the SQL Server 2012 Integration Services Instance, but when I run it as a J...

Id #20841 | Release: None | Updated: Apr 17, 2014 at 7:30 PM by BrrIsTeam | Created: Mar 20, 2014 at 10:14 PM by BrrIsTeam

Error: System.ServiceModel.CommunicationException

Hello, We can use sharepoint lists in SSIS when we execute the package in visual studio SSDT but when deployed and executed on our ssis-server we get this error: Error: System.ServiceModel.Commun...

Id #20830 | Release: None | Updated: Mar 25, 2014 at 7:58 AM by an1e | Created: Mar 18, 2014 at 3:25 PM by JonKa