SSIS - SharePointUtility.DLL

Jun 19, 2015 at 9:09 PM
I am trying to retrieve only particular columns from SharePoint list. Unfortunately, CAML query in Sharepointlist source only allows rows to be filtered, but not columns. The workaround I am trying it to use the SharePointUtility.DLL and download through C# program. Do some one know where to find this DLL? according to Kevin's word document, it is installed during SharePointList adapters installation. Can some one help?

Thanks in advance!
Jun 22, 2015 at 10:34 PM
closing this question..

in advanced editor, we can remove columns that we don't need.

answer lies in FAQ.

Q: Using the SiteListViewName, I still see all of the columns of the original list__

This is because views only filter the data rows from the backend that we're querying against, they do not filter the column data. If you want to remove columns from the Adapter, you can use the advanced tab and simply remove them. See the "Selecting Columns" Section of the MSDN Instructions.
Marked as answer by ctsbala on 6/22/2015 at 2:34 PM