Uploading file to SharePoint Document Library using SSIS

Question

Uploading file to SharePoint Document Library using SSIS

rktn_odin

SSChasing Mays

Points: 636
More actions
February 23, 2011 at 4:05 am

#149969

Hi all,
I am sorry if this is already answered somewhere or does not belong to this forum (or worst to this site).
How can I upload a file to SharePoint Document Library through SSIS?
I could not find any built-in function in SSIS to do that task.
Thanks before 🙂

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

ssills Old Hand Points: 375 More actions · Answer 1

A document library *should* be no different than a network share, except that you use an http address instead of a UNC address.

rktn_odin SSChasing Mays Points: 636 More actions · Answer 2

Hi ssills, thanks for replying.

Do you know how to create (or get) UNC path from SharePoint Document Library?

TangoVictor SSChampion Points: 10975 More actions · Answer 3

I have a similar post to this but mine is reading a file. Anyway the UNC path would be something like this

\\mysite.com\subsite\....\docLib\myfile.ext

Do this through windows explorer to see if you can access the site. My problem has been authenticating when running the job, but I'm pretty sure this is a win 7/2008 issue.

ssills Old Hand Points: 375 More actions · Answer 4

The path in Explorer actually begins with http. It's easy enough to get: go to a document library, select Actions, then Open with Windows Explorer, and copy that address and past it into SSIS.

For Sharepoint 2010, the Library tab on the ribbon bar has an icon for "Open with Explorer."

rktn_odin SSChasing Mays Points: 636 More actions · Answer 5

I have resolved my problem. I create custom console application to upload file to document library, and then execute it from SSIS via Execute Process Task.

But I wonder, I have site with port 7777. So what exactly the UNC looks like?

\\mysite:7777\folder\subfolder

I tried and it fails to open.

TangoVictor SSChampion Points: 10975 More actions · Answer 6

ssills (2/25/2011)
The path in Explorer actually begins with http. It's easy enough to get: go to a document library, select Actions, then Open with Windows Explorer, and copy that address and past it into SSIS.
For Sharepoint 2010, the Library tab on the ribbon bar has an icon for "Open with Explorer."

Have you ever done this and used that connection in SSIS? If so please explain exactly how.

rktn_odin SSChasing Mays Points: 636 More actions · Answer 7

Hi Tom, if you still having trouble, you can try my workaround it works perfectly.

I found the code (of course I modified it for my case) on other site but forgot which one. You can try google it.

EDIT:

Sorry just noticed, in your case, you want to read file from document library. But anyway, I think you can try using custom console application (of course using C# or VB .NET) to read file and then copy it to local and finally do some logic to that local file.

d_george SSCrazy Points: 2462 More actions · Answer 8

With SQLs 2014-2016, is there a better (toolbox destination) way to upload a file to SP 2016 via SSIS?