CODEWITHSUNDEEP
sql-serversharepointssis
Frederik
Frederik

Reputation: 2188

Sharepoint document library as a destination in SSIS

I create a CSV-file from SSIS and I want to "publish it" in a specific folder in our Sharepoint document library. What is the preferred way to this?

I have looked at the example with the sharepoint list destination SharePoint List Source and Destination which is quite good but not exactly what I'm out for. I just want to upload a file to the document library from within SSIS.

Upvotes: 2

Views: 6557

Answers (2)

adolf garlic
adolf garlic

Reputation: 3096

Another alternative is to send an email to the doc library.

The doc lib owner needs to set up the email address on the page options, this will give you an email that looks like

[email protected]

If the folder ever gets moved around, as long as the email remains, you don't need to worry about it

Upvotes: 1

Nat
Nat

Reputation: 14305

SharePoint uses WEBDAV to provide a folder like locations. You can see an example of this by going to the list in question and selecting actions-> open with explorer.

Upvotes: 1

Related Questions