Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-09 : 08:29:51
|
| Trent writes "Hi my friends at SQLteam,I am pulling my hair our due to a SSIS questions, hopefully you can 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" |
|
|
|
|
|
SSIS 05: load excel data from sharepoint doc library to SQL