Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
We are using the SPCRED source (from CODEPLEX?) in SSIS to read a SharePoint list, but due the changing nature of the list (not under my team's control) I want to read only one column so that changes don't break my process.
I noticed that there is a CAML Query property, but it seems that the syntax only allows filtering, not selection of columns. So I don't think that will work.

I could add a view with only the one column -- but then everyone will see it, and maybe someone will delete it.

I could use OleDb to query the list -- I think I'll do that as a work-around for now.

Does anyone out there know of a way to limit the columns returned by SPCRED?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900