November 21, 2012 archive

Scraping HTML Tables into SQL Server Using SSIS

At work, I am attempting to scrape a table off an intranet webpage so that I can import its contents into Microsoft SQL Server so I can obtain more frequent updates for a small but critical subset of data that I would normally only receive once a day. Using this information I would also be …

Continue reading