Import Sharepoint Document Library using SSIS

Question

We need to import SharePoint Document Library (which could be holding multiple document in multiple formats) to a destination folder (on different server) using SSIS.

social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/… — Dennis G
– Dennis G, Commented Sep 12, 2012 at 20:35
Why do you want to use SSIS for this? Why not write a small application to do it? Also, which version of SharePoint? — John Saunders
– John Saunders, Commented Sep 13, 2012 at 2:23

Raheel · Accepted Answer · 2012-09-13 02:21:18Z

3

There are open source SSIS adapters available for SharePoint. You can use these.

http://sqlsrvintegrationsrv.codeplex.com/ http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

answered Sep 13, 2012 at 2:21

Raheel

5708 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BestDataPros · Accepted Answer · 2017-08-07 18:44:42Z

1

You can also create a script task in ssis and use c# to extract files from SharePoint Library to a local folder. Make sure the SharePoint url only contains siteurl/Library/Folder/File (no special characters). Below copies one file but can be modified to copy multiple files. Good luck.

using System.net;


public void main ()
{
WebClient Client = new WebClient();
Client.UseDefaultCredentials = true;
Client.DownloadFile("yourSharePointurl/File.ext", 
@"YourLocalFolder/File.ext");
Dts.TaskResult = (int)ScriptResults.Success;
}

answered Aug 7, 2017 at 18:44

BestDataPros

494 bronze badges

2 Comments

Unbound Over a year ago

I tired this and it gives an error: "Exception has been thrown by the target of an invocation"

variable Over a year ago

Same error for me as well Exception has been thrown by the target of an invocation - any solution?

Arjun Dayanandan · Accepted Answer · 2022-11-17 18:04:12Z

0

Change this "using System.net;" to using "System.Net;"

My compilation error got fixed

answered Nov 17, 2022 at 18:04

Arjun Dayanandan

213 bronze badges

Collectives™ on Stack Overflow

Import Sharepoint Document Library using SSIS

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related