August 7, 2004 at 4:12 am
i'm new to SQL, what i'm trying to do is get stock quotes from ft.com onto my site. is it possible to do this with SQL? so when ft.com updates the stock value, this will be reflected on my site.
thanks
August 9, 2004 at 9:47 am
I don't exactly know what you are going to do but if you want to get the feed from ft.com by using ftp with csv file or something and upload to your sql, yes, that would be easy by using DTS package.
Not sure ft.com does that but if you just want to post the stock quotes on your site, the xml feed is also good choice.
August 9, 2004 at 11:03 am
You will need some type of process to download the data. This probably needs to be via HTML, XML, or even csv. One thing you have to be sure is that you have an agreement with ft.com. Most sites "own" the stock data and you cannot scrape their site for the price.
August 11, 2004 at 2:48 am
as i said am am new to this:
1) whats a DTS package?
2) how do i do the xml feed
3) if i use ftp with csv, how do i automate the download from ft.com and automate the upload to my site?
4) the site i'm scraping data off wouldnt know i am doing it would they?
I only though of doing this cos in MS Excel u can import data into a spreadsheet in this way, but i want something for a webpage, so ppl without MS Excel can access it
thank you in advance
August 16, 2004 at 10:42 am
Hi Luke,
DTS package is Data Transformation Service and is built in function of SQL7.0 or up so if you install SQL server 7.0 or up, you already have. Many people uses for Data Warehousing data migration but you can use that for other stuff like you want to do. Like Steve already mentioned that you need to talk to ft.com site first. Read about DTS package and starts from there. Or you can even do it from asp/aspx as well.
I can't tell you how to step by step if you don't even know DTS package but basically, you make a package to download the file and upload to maybe staging table and do data migration and then load to production table.
Sorry that I can't be more helpful
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply