January 5, 2011 at 1:04 pm
Hi,
I need to generate summry of our data in excel format. I have setup DTS package to run the query and create csv file and file is stored on shared folder on network for other people. Now we have sharepoint site and management want all these information on sharepoint folder automatically.
I have never used sharepoint before and it seems easy but don't know how to copy a file on sharepoint folder from DTS package. Can anyone please give me some direction?
Thanks.
January 5, 2011 at 1:41 pm
If I recall and it may depend on how your SharePoint is configured you can reference a document list in SharePoint like a UNC path.
Example if my document list name is http://department.mysite.com/Documents/Forms/AllItems.aspx
I believe you can reference it like \\department.mysite.com\documents. A search for something like "UNC path to sharepoint folder" will probably get you something you can work with. The only thing you may have to work out is what permission the account needs to access it. It has been a while since I've worked with SharePoint in that manner.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2011 at 3:34 pm
Nope, You can't just use UNC and copy the file, I believe everything is stored on SQL server not on file server.
January 7, 2011 at 5:31 pm
mak101 (1/7/2011)
Nope, You can't just use UNC and copy the file, I believe everything is stored on SQL server not on file server.
You are correct in that the files are stored within the content database for the SharePoint site. However, I'm afraid I have to disagree with not using the UNC path. I have done this in a enterprise environment for a previous employer. I also used it to migrate some documents from one site to another.
Then you also have this article to reference: Accessing SharePoint Document Library through UNC Path.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply