Hi all,

I have a small SSIS package which reads an Excel file and insert data in a
DB.
Right now I am using Excel connection manager to read from my Excel file as
the file is located on the local hard drive.

In the future, the Excel file will be located on a web server. How can i get
that file from a webserver within SSIS. I saw an HTTP Connection manager
object but i don't know how to consume it.
I currently have an Excel source object that consumes my Excel Connection
but i have no idea how to connect my HTTP connection to my Excel data
source...
Also the SSIS doc says that "An HTTP connection enables a package to access
a Web server by using HTTP to send or receive files". If so how do i specify
the location where the file will be downloaded? If I could specify that then
i could connect to that file with the EXcel connection manager which in turn
will feed my Excel data source.

Thanks for any help,

Best regards,

Francois Malgreve

To share information for other people, I found a solution to my problem
described there:

http://www.sqlservercentral.com/foru...ssageid=239384

Francois.


"Francois Malgreve" <francois.malgreve (AT) _NON_SPAM_gmail (DOT) com> wrote