Home > SQL Integration Services > How to use SSIS to extract permission assigned to each folder within a SharePoint List – Part 4 (of 5)

How to use SSIS to extract permission assigned to each folder within a SharePoint List – Part 4 (of 5)

Steps 3 – Use a “Execute SQL Task” to retrieve the list

I just use this: select * from dbo.SharePoint_FolderList

Steps 4 – Use a “For Each Loop” to loop through each foler

Steps 5 – Within the for each loop, use a script component to extract permission and write to the SQL table

Add the reference to the Microsoft.SharePoint and add the following in your code

using Microsoft.SharePoint;

using System.Data.SqlClient; //This is required for "SqlConnection" 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: