December 28, 2005 at 2:53 pm
Hi experts:
Please help me out:
An excel file is located on a sharepoint site's document library, like: http://www.abc.com/docLib/myexcel.xls
When I access the file from IE, I need to type domain name, username and password.
Customers will change myexcel.xls periodically from the sharepoint site, whenever the file changes, a SQL Server Integration Service (SSIS)task will be activated to load the latest myexcel.xls to a SQL Server table.
My question is: how shall I implement the SSIS package to import the excel file to a SQL server table, I could not find a place in SSIS to configure the username and password for the sharepoint website to access the excel file. Your suggestions are highly appreciated!
I searched and found this might work: To use SSIS script task to download the file from sharepoint site to local drive, then use SSIS to load the excel file locally. However, I do not know how to write the SSIS script to download files that is password protected. And I hope there are better options.
Thanks in advance!!!
Trent
December 28, 2005 at 5:41 pm
search this site with the keywords "download excel" and there are about 15 posts on the subject over the past two years... did not see anything specifically for sharepoint; but I believe the topic has been covered. Over the years I have scripted FTP to do my file transfers, and fired them from batch/command files; but I do believe what you are trying to do is feasible. Openrowset may have something interesting to do with it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply