By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

SSIS Import

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.