468,107 Members | 1,267 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

SSIS Import

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.

Feb 9 '07 #1
1 5468
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" <ev******@yahoo.comwrote in message
news:11*********************@a34g2000cwb.googlegro ups.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.

Feb 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by mattc66 via SQLMonster.com | last post: by
2 posts views Thread by othellomy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.