SharePoint List Data Source Adapter and UserMulti Lookups

When trying to pull data from a sharepoint list, I have 2 types of lookups multi-valued lookups and multi-user lookups. Sample of the XML <FieldRef Name="Server_x0020_Name" StaticName="Server_x...

Id #21782 | Release: None | Updated: Mar 17 at 2:13 PM by arenzja | Created: Mar 17 at 2:13 PM by arenzja

Username argument is invalid

I was able to force the 4 extensions to load in SSIS in VS 2013 however I'm not able to use them because the source connectors are both throwing the following error. Has anyone encountered this and...

Id #21746 | Release: None | Updated: Mar 2 at 7:04 PM by tedliq | Created: Mar 2 at 7:04 PM by tedliq

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: Mar 9 at 6:59 PM by motricio | Created: Jan 20 at 8: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: Feb 26 at 12:19 PM by Rockie | Created: Oct 13, 2014 at 6: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 2:13 PM by stevelayton | Created: May 22, 2014 at 2: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 3:42 AM by WangYubo | Created: May 8, 2014 at 12: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 8:18 AM by Maaheswaran | Created: Apr 24, 2014 at 8: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 1:49 PM by zubair25nov | Created: Apr 23, 2014 at 1: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 9:18 AM by cpassuel | Created: Apr 16, 2014 at 8: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: Jun 11 at 4:18 AM by debnathrajdeep | Created: Apr 15, 2014 at 6:41 AM by BBGONE