Sharepoint document library as a destination in SSIS

Question

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.

Answer 1

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.

Answer 2

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

Answer 3

see samples from :

http://weblogs.sqlteam.com/randyp/archive/2010/02/16/61102.aspx