Posted by AlterEgo on 02/10/07 00:14

Eric,

Unless you want to write an HTML parser, having Excel in the middle might be
the way to go. One way to improve the process might be top work with the
Excel object entirely within your code so there is no manual aspect to the
process.

-- Bill

"Eric" <evajen01@yahoo.com> wrote in message
news:1171065013.617849.11960@a34g2000cwb.googlegroups.com...
> 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]