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:
| Updated: Thu at 3:46 PM by MSDN_UZR | Created: Thu at 3:46 PM by MSDN_UZR
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:
| Updated: Mar 11 at 7:44 PM by spcysp | Created: Mar 11 at 7:44 PM by spcysp
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:
| Updated: Apr 12 at 2:02 PM by Lorax74 | Created: Mar 11 at 4:01 PM by gbritton
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:
| Updated: Mar 3 at 11:52 AM by Smitasml123 | Created: Mar 3 at 11:52 AM by Smitasml123
The MERGE Destination failed during the create TVP step when the source/target contains an nvarchar(max) column.
Incorrect syntax near ')'.
Sample TVP create:
create type TVPType8b78e67fe...
Id #22181 | Release:
| Updated: Feb 25 at 8:16 PM by jbelina | Created: Feb 25 at 7:04 PM by jbelina
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:
| Updated: Feb 19 at 10:34 PM by haidongh | Created: Feb 19 at 10:34 PM by haidongh
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:
| Updated: Jan 14 at 2:41 PM by gbritton | Created: Jan 6 at 1:49 PM by gbritton
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:
| Updated: Dec 15, 2015 at 1:38 PM by gbritton | Created: Dec 15, 2015 at 1:38 PM by gbritton
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:
| Updated: Jan 5 at 9:43 AM by NeilM89 | Created: Dec 15, 2015 at 12:58 PM by suryap
We successfully created and run the SSIS Package using SharePoint List adapter. In VS it is working fine, but when we try to run from the SQL agent it throwing the below error.
Id #22111 | Release:
| Updated: Dec 10, 2015 at 4:10 AM by axix_911 | Created: Dec 10, 2015 at 4:10 AM by axix_911