Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft SharePoint.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft SharePoint, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Microsoft SharePoint Stored Procedures
| Name | Description |
| AddAttachment | Add an Attachment to a SharePoint List item. |
| AddList | Creates a list on a SharePoint site. |
| AddListColumn | Adds a new column to the specified list. |
| AddUserToGroup | Add the user to specified group. |
| AddUserToRole | Add the user to specified role. |
| CheckInDocument | Checks in a document to SharePoint and releases the lock on the document. |
| CheckOutDocument | Checks out a document from SharePoint. |
| CopyDocument | Copies a document from the SharePoint library. |
| CreateFolder | Adds a folder to a document library on a SharePoint site. |
| CreateSchema | Creates the schema file for the specified SharePoint list. The schema file may be customized manually to exclude unwanted columns or include additional information about columns. |
| DeleteAttachment | Deletes an attachment from a SharePoint list item. |
| DeleteDocument | Deletes a document on the SharePoint library. |
| DeleteList | Permanently deletes a list from a SharePoint site. |
| DeleteListColumn | Deletes a column from the specified list. |
| DeleteUserFromGroup | Deletes the user from the specified group. |
| DeleteUserFromRole | Deletes the user from specified role. |
| DiscardCheckOutDocument | Discards a check out on a document in SharePoint. This does not check a new file into SharePoint. It only releases the lock on the document. |
| DownloadAttachment | Downloads a document from the SharePoint list. |
| DownloadDocument | Downloads a document from the SharePoint library. |
| MoveAttachmentOrDocument | Moves a document or attachment from a source folder to a destination folder. |
| RenameAttachmentOrDocument | Renames a document or attachment. |
| UpdateList | Updates a list on a SharePoint site. |
| UpdateListColumn | Updates a column in the specified SharePoint List. |
| UploadDocument | Uploads a document to the SharePoint library. |