Discussion:
SSIS: How to import CSV files from a HTTP location
(too old to reply)
Max2006
2009-04-01 03:11:20 UTC
Permalink
Hi,

I am trying to import a CSV file from a HTTP location. Is there any sample
or documentation that explains how to do that?

Thank you,
Charles Wang [MSFT]
2009-04-01 09:00:29 UTC
Permalink
Hi Max,
Welcome to Microsoft MSDN Managed Newsgroup Services.

From your other posts, I think that you would like to import the structured
table data from a web page (Http location) to a CSV file, right?

As I mentioned in your other two posts, I recommend that you 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/library/system.net.httpwebrequest.haverespon
se(VS.80).aspx
http://msdn.microsoft.com/en-us/library/bb463974.aspx
http://www.codeguru.com/columns/dotnet/article.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: ***@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Max2006
2009-04-01 15:14:35 UTC
Permalink
Thanks Charles, I misunderstood the HTTP connection manager. Thanks
again...Max
Post by Charles Wang [MSFT]
Hi Max,
Welcome to Microsoft MSDN Managed Newsgroup Services.
From your other posts, I think that you would like to import the structured
table data from a web page (Http location) to a CSV file, right?
As I mentioned in your other two posts, I recommend that you 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
http://msdn.microsoft.com/en-us/library/system.net.httpwebrequest.haverespon
se(VS.80).aspx
http://msdn.microsoft.com/en-us/library/bb463974.aspx
http://www.codeguru.com/columns/dotnet/article.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
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Loading...