Loading html file data to SQL Server table

• kashyap4007

  SSC Eights!

  Points: 859

  More actions

  September 7, 2018 at 8:28 am

  #367807

  HI,

  I have data in a website and I want to load that to my database.

  For now, I am looking for only a partial data elements to be brought to my database ( Marked them in the below pic).

  

  I have a Script Task which pulled the data from the above site and created an HTML file.

  Can you help me load the data from this file to my database?

  I would like to know if there is a better solution for this also.

  FYI... Below is the link for the HTML file.

  https://drive.google.com/open?id=1AWIXxosFT2ua3j3Eu6u46TUK6TWjapD4

  Thank you.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 7, 2018 at 12:44 pm

  #2004938

  kashyap4007 - Friday, September 7, 2018 8:28 AM

  HI,

  I have data in a website and I want to load that to my database.

  For now, I am looking for only a partial data elements to be brought to my database ( Marked them in the below pic).

  

  I have a Script Task which pulled the data from the above site and created an HTML file.

  Can you help me load the data from this file to my database?

  I would like to know if there is a better solution for this also.

  FYI... Below is the link for the HTML file.

  https://drive.google.com/open?id=1AWIXxosFT2ua3j3Eu6u46TUK6TWjapD4

  Thank you.

  Several different ways to do this are addressed in this article:
  How to Import Data from HTML pages

  Sue