Posted by Eric on 02/09/07 23:50

In MS Excel, the ability exists to run a "web query." This function
is accessed via the data menu's import external data option. The web
query wizard accepts a URL address, and then is able to import the
data from that address into an excel worksheet.

What I would like to do is use SSIS to import data from the same web
site. In other words, I now use Excel's web query functionality to
import data from a website with a url of xyz.asp. I save the excel
workbook, and then run a DTS package to import the data into SQL
Server. I would like to entirely bypass Excel, instead of using it as
an intermediary to bring data from the asp site into SQL Server.
However, I can't figure out how to set up the connection from SQL
Server. I am using SQL Server 2005, SSIS. Is there a way to have
SSIS open the asp website, extract the data and import it into a SQL
Server table?

For the record, this is not XML data.

Thanks.

[Back to original message]