SharePoint 2016 Support

Please upgrade to support SharePoint 2016 and SQL Server Management Studio 2014.

Id #22270 | Release: None | Updated: May 18 at 10:21 PM by pcooper | Created: May 18 at 10:21 PM by pcooper

Unable to use SharePoint Adapter

Hello, I am using Visual Studio 2013. I downloaded MS Data Tools so that I can create SSIS packages. I also downloaded the SharePoint adapter from here: http://sqlsrvintegrationsrv.codeplex.com/re...

Id #22258 | Release: None | Updated: May 5 at 3:46 PM by MSDN_UZR | Created: May 5 at 3:46 PM by MSDN_UZR

EzAPI memory issues and disposing objects

There doesn't appear to be a way to clean up EzAPI objects. For example, every time I construct an EzDataFlow object, I see that both memory usage and the number of handles increase but I have no w...

Id #22203 | Release: None | Updated: Mar 11 at 7:44 PM by spcysp | Created: Mar 11 at 7:44 PM by spcysp

SharePoint List Adapter not respecting the SP View

I'm using the SP List adapter in my project. Initially I set it to use the default view. (about 140 columns) Later I changed it to use a custom view with only 20 columns. I hit Refresh but the ad...

Id #22202 | Release: None | Updated: Apr 12 at 2:02 PM by Lorax74 | Created: Mar 11 at 4:01 PM by gbritton

The task user interface specified by type name 'Microsoft.Samples.SqlServer.SSIS.HelloWorldTask.HelloWorldTaskUI, HelloWorldTaskUI,

When I double clicked on this Task, below error occur. The task user interface specified by type name 'Microsoft.Samples.SqlServer.SSIS.HelloWorldTask.HelloWorldTaskUI, HelloWorldTaskUI, Version=1...

Id #22191 | Release: None | Updated: Mar 3 at 11:52 AM by Smitasml123 | Created: Mar 3 at 11:52 AM by Smitasml123

MERGE Destination fails to create TVP

The MERGE Destination failed during the create TVP step when the source/target contains an nvarchar(max) column. Error: Incorrect syntax near ')'. Sample TVP create: create type TVPType8b78e67fe...

Id #22181 | Release: None | Updated: Feb 25 at 8:16 PM by jbelina | Created: Feb 25 at 7:04 PM by jbelina

The SharePoint List connector for SSIS fails to connect to the SharePoint site with NTLM authentication HTTP 401 error in the 2015 build

When you try and run a sample package which pulls data from SharePoint list from SSDT, it runs fine. But when you run this package from SSISDB Catalog after you deploy it to SSISDB Catalog, you get...

Id #22173 | Release: None | Updated: Feb 19 at 10:34 PM by haidongh | Created: Feb 19 at 10:34 PM by haidongh

Exception deserializing the package "The package failed to load due to error 0xC0011008 "Error loading from XML.

Using SSDT-BI for 2012 with all available updates applied and a fresh copy of the Sharepoint List Connector, I get the exception pasted below. However, when I run it with dtexec, it executes norma...

Id #22132 | Release: None | Updated: Jan 14 at 2:41 PM by gbritton | Created: Jan 6 at 1:49 PM by gbritton

The component has detected potential metadata corruption during validation.

I've been using the SharePoint List Source component (SharePoint List Source component) for a while now. Today I tried to hook up a new source and got the error message: The component has detected...

Id #22119 | Release: None | Updated: Dec 15, 2015 at 1:38 PM by gbritton | Created: Dec 15, 2015 at 1:38 PM by gbritton

System.ServiceModel.CommunicationException: The underlying connection was closed

Hi, We have been using this adapter for quite some time. We are now facing issues intermittently. The error message we receive is "System.ServiceModel.CommunicationException: The underlying conne...

Id #22118 | Release: None | Updated: Jan 5 at 9:43 AM by NeilM89 | Created: Dec 15, 2015 at 12:58 PM by suryap