After installation, the source component will appear in SSIS Toolbox as below:
To use the component, first of all you need to create a SPREST connection. Right click anywhere in Connection Managers pane, select "New Connection". "Add SSIS Connection Manager" window will show. Select "SPREST" from the list.
A "SharePoint Connection Manager Editor" window will show:
Enter or select appropriate values based on your environment. Note "Integrated Authentication" means the current user's credentials will be used to connect to SharePoint; "Windows Authentication" means the specified user's credentials will be used.
In "Advanced Editor for SharePoint List Source", you can select the connection created before:
Then you can specify the following custom properties:
"Expand Lookup" decides if lookup/user fields are returned as ID or value, and if the secondary lookup fields are returned.
|
