May 10, 2012 at 2:14 am
Hi,
I am trying to get data from a web page (stock market site have top gainers/losers table).
Created a web query in excel, and imported the excel data to sql table, using DTS packages, and schedules jobs to run every 3 minutes.
But If have the Excel running to refresh data very 1 minute, my scheduled jobs fail.
But if the excel is closed, the jobs are running fine, but then there will not be any data updates.
How can i have an automated job to get the web data to my sql table.
Thanks.
June 21, 2012 at 3:43 am
Hi, i have the same problem.
I need webdata in sql table and want to cur our the "data from web" out of excel.
Does anyone have a solution?
June 21, 2012 at 4:03 am
does excel sheet call a web service?
June 21, 2012 at 4:08 am
Well in excel it extracts a number form a website, on the web page there is only a number i want to import into a sql table.
June 21, 2012 at 4:14 am
Have you tried using SSIS with a web service task to query the website, then store it to a variable of type object, then use that variable as an insertion object into the database.
June 21, 2012 at 4:19 am
What is SSIS?
June 21, 2012 at 4:21 am
SQL Server Intergration Services - Basically the new and improved DTS in SQL 2005 onwards.
June 21, 2012 at 4:23 am
ok, i thought this was going to be easy. my sql knowledge is still limited.
I'm using postgreSQL, can this be done in the as well?
June 21, 2012 at 4:25 am
I am running SQL 2005, so do i need to install nay add-on patches to my sql server?
June 21, 2012 at 4:27 am
@Hein 50303
Unsure on PostgreSQL, you will need to see if it has tools like SSIS in SQL. If you have MS SQL on a different server, then just install the PostgreSQL ODBC driver and link your SQL server which can run SSIS to your Progress DB.
Also please note that this is primarily a Microsoft SQL Server site, you might be best posting PostgreSQL questions on a dedicated PostgreSQL forum.
As long as you have Business Intelligence Development Studio installed on your local machine to develop SSIS packages then no.
If you dont have SSIS expereince, I would recommend looking through the Stairways section to get some expereince with SSIS as its very different to DTS.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy