dbTalk Databases Forums  

SSIS: How to import CSV files from a HTTP location

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS: How to import CSV files from a HTTP location in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Max2006
 
Posts: n/a

Default SSIS: How to import CSV files from a HTTP location - 03-31-2009 , 10:11 PM






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,


Reply With Quote
  #2  
Old   
Charles Wang [MSFT]
 
Posts: n/a

Default RE: SSIS: How to import CSV files from a HTTP location - 04-01-2009 , 04:00 AM






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/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.
================================================== =======






Reply With Quote
  #3  
Old   
Max2006
 
Posts: n/a

Default Re: SSIS: How to import CSV files from a HTTP location - 04-01-2009 , 10:14 AM



Thanks Charles, I misunderstood the HTTP connection manager. Thanks
again...Max


""Charles Wang [MSFT]"" <changliw (AT) online (DOT) microsoft.com> wrote

Quote:
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/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.
================================================== =======






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.