We are using SQL Server 2005 Integration Service (SSIS) to import data from
an EXCEL source file, which is on a secured web site(need login), like:
http://www.abc.com/myexcel.xls

I was trying to add a connection and use EXCEL data source in the format
below:
\\www.abc.com\myexcel.xls

I could not find a place in SSIS to configure the username and password for
the website login to access the excel file.

How can I load excel data in this case? Any help is greatly appreciated!