Post reply

Loading html file data to SQL Server table

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply