Hi,

I am trying to find the right usage for “HTTP Connection Manager”. After
some research I found the following samples:

SSIS: Downloading a file over HTTP
http://sqljunkies.com/WebLog/ashvini.../25/15653.aspx


Fetch file from http (web) server using SSIS?...
http://www.sqlservercentral.com/Foru...384-148-1.aspx

Both samples rely on scripting to download a file from a HTTP url. However,
when it comes to scripting, .NET Framework has extensive support for HTTP
clients. So what is the point of HTTP Connection Manger in SSIS? Is there
any task (other than web service) that is able to use HTTP connection
manager?

Thank you,

Hi Max,
Welcome to Microsoft MSDN Managed Newsgroup Services.

HTTP connection is only used for sending (uploading) or receiving
(downloading) files via HTTP. You can refer to
http://msdn.microsoft.com/en-us/library/ms186988.aspx.
Currently there is no other task that is able to use HTTP connection
manager other than the Web Service Task.

For your requirement, you may consider using Script Task to write some .NET
code to access the web page via HttpWebRequest and extract part of the
table in XML and parse the XML snippet into a dataset and then transfer the
data into the your database table. You may refer to the following articles:
http://msdn.microsoft.com/en-us/libr...est.haverespon
se(VS.80).aspx
http://msdn.microsoft.com/en-us/library/bb463974.aspx
http://www.codeguru.com/columns/dotn...php/c11141__2/

Hope this helps! Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======