I updated my existing SharePoint List Source/Destination projects to the newest release. When I want to choose/change the Connection within the SharePoint List Destination I get the following error:
[SharePoint List Destination : System.InvalidCastException: Unable to cast object of type 'System.Data.SqlClient.SqlConnection' to type 'System.Net.NetworkCredential'. Instances of type that represent COM components cannot be cast to types that do
not represent COM components; however thay can be cast to interfaces as long as the underlying COM component supports QueryInterface call for the IID of the interface.
at Microsoft.Samples.SqlServer.SSIS.SharePointListadapters.SharePointListDestination.Acquireconnections(Object transaction)
I tried different connection types ADO, OLEDB with Windows Authentication and SQL Login, but nothing helps. I saw that someone other had the same problem. But there is no solution mentioned...
It would be great if some can help me.
Thanks in advance.