Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData SSIS Components for Microsoft SharePoint Views
| Name | Description |
| Attachments | Reads attachments to the specified item to the specified list. |
| Files | Reads attachments to the specified item to the specified list. |
| Groups | Query the available groups on your sharepoint site. |
| Lists | Query the available lists on your sharepoint site. |
| RoleAssignmentMember | Get Web RoleAssignments member. |
| RoleAssignments | Acquires Web RoleAssignments. |
| RoleDefinitionBindings | Get Web Role definition binding. |
| Roles | Query the roles your users can have. |
| Subsites | This lists the available subsites. |
| Users | Query the available users on your sharepoint site. |