How to Write to Office SharePoint Server 2007 (MOSS 2007) from SSIS

If you are not a SharePoint Admin (I am not) but need to interact with MOSS 2007 and SSIS, this guide should walk you through the basics.

 

First, and this is the most important part,  you must enable a service on the Windows Server 2003 box.   The service is WebClient – enable it, then set it to autostart.

 

Now, Open up SharePoint and Navigate to your Document Library – I am using the MOSS 2007 VPC so mine is: https://moss.litwareinc.com/SiteDirectory/EDTDocs/Shared%20Documents/Forms/AllItems.aspx.

 

Now you have 2 choices, you can map a drive (  net use * "\\moss.litwareinc.com\SiteDirectory\EDTDocs\Shared Documents" will do the trick for that.)  Or you can address it as a UNC Path like this:   \\moss.litwareinc.com\SiteDirectory\EDTDocs\Shared Documents.

 

Now, when you have a file destination in SSIS you can make it your mapped drive or the UNC path.

 

I hope this helps someone; it took me days to get this right.