none
HTML Table as data source

    Question

  •  

    I have a client, who has data feeds as HMTL, we need to import this data to SQL Server 2008. I'm trying to figure out what is the best way to use SSIS to perform this task.

     

    Wednesday, November 26, 2008 7:05 AM

All replies

  • There isn't an out of the box component to do this, so I would suggest one of the following:

     

     

     

    1. Use a script task to parse the file and pull the data into a datatable/dataset. You can set this result to the SSIS package variable Object type

     

    or

     

    Parse the HTML table into XML and then you can use the XML Source object: http://www.codeproject.com/KB/cs/HTML_Table_Into_XML.aspx. You could obviously do a similar operation and parse it into a CSV, either way.

     

    2. If you chose the Script task option, then your datasource will be a the ADO.NET datasource (setting its source to the Object that is the output of the script task). Or if you chose to parse the file into XML or a CSV, then your source will be a flat file of type xml or csv.

     

    Hope that gets you started.

     

    Wednesday, December 03, 2008 5:45 PM