MS SQL Server DTS - SSIS 05: Load Excel data from a website (need login)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS 05: Load Excel data from a website (need login)

Trent

2005-12-22, 3:24 am

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!

Sponsored Links