I have asked the similar question few days ago, but nobody responsed. So I am
asking again with more detailed info: =======>

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!!!