Upload document to sharepoint document library using SSIS
I am able to upload document to document library using Filesystem task. But I would like to know if there is any alternative method such as web services task of accomplishing the same. I am not able todownload wsdl file for the sharepoint site. Since I am a SQL Server DBA at core, I am not used to programming in C# or .Net. Any help would be appreciatedMy laptop is winXP SP2 and the sharepoint server is Windows 2003 R2. I am using reporting services to schedule the report subscriptions to a designated folder, from where this task will upload the subscriptions to specified document library. Unfortunately Filesystem task does not work when the package is executed from the server.
August 5th, 2009 7:07am

hi Ashish,Not sure about Share point part as havent worked on that.As far as the File System task not working on the server............How are u executing the package on the server?What is the error msg ur getting?Does the user under which the package is run have permission to the folder & File mentioned in the task?Hope this helps !! - Sudeep | Please mark the post(s) as Answered that answers your query.
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2009 7:21am

Yes, I have all the permissions since I am the administrator of the server as well as the sharepoint siteI am getting the message that the sharepoint server folder does not exist. I have even tried browsing the UNC path of the sharepoint server and it gives error from the server. Also the sharepoint adapters for sharepoint source and sharepoint destination do not correctly install on the server. Hence I suspect there is some issue with the server. If I can have the alternative method and that too fails on the server then only I can put forward my point to the management.Ashish
August 5th, 2009 7:26am

If you are not able to browse the folder the package will also not be able to access the folder hence the error.Similar error will come for all methods which use ur credentials.Hope this helps !! - Sudeep | Please mark the post(s) as Answered that answers your query.
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2009 7:33am

My main question was NOT FileSystem task not working on the server, but an alternative method like web services task to upload the document(s) to sharepoint document library, so my question still remains unanswered.ThanksAshish
August 5th, 2009 8:34am

Ashish,For alternatives to uploading files to SharePoint please query the SharePoint forum (http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/threads). If there is a webservices endpoint, then using the Web Services Task or a script task will be possible.Good luck,PatrikThis posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2009 1:49pm

I am able to upload document to document library using Filesystem task Dear Ashish, I am interested in know how you achieved uploading files to a sharepoint library using FileSystem Task in SSIS Package. Will you be able to guide me thru. Thanks in advance. Regards, Vinu Regards, Vinodh
July 19th, 2012 10:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics