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.
@wrathyimp
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 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply