Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-31 : 08:34:03
|
| Tammy writes "What would be the best way of integrating a data feed consisting of end of the day stock prices for 4,000 companies? The feed is being delivered once a day via FTP in a comma-seperated file. The data will be used by about 1,000 users via a web application. Any help would be much appreciated!!thx,-tammy" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-07-31 : 09:00:05
|
| I would use either DTS, BCP or BULK INSERT to import the file into SQL Server and then use T-SQL to manipulate, normalize, clean and prepare your data for use. Use a SQL Server Agent Job to schedule this process.Jay White{0} |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-07-31 : 09:03:56
|
| at a simplistic level...i'd ask "integrating with what?"if you want it loaded into a SQL table...then a BCP or DTS task would do the job....either of these tasks could be wrapped inside a stored procedure which could be scheduled for a SQL agent to action....or could be scheduled themselves if the ftp file never changes name.more info would be required, including what is going to be done with the info in sql....if at all....(web applications can open csv files...not pretty....but that's a presentation issue) also what's to be done with the ftp file after a load....and/or if you anticipate running process to 'transform' raw data into user-friendly (+ readable) information.... |
|
|
|
|
|
|
integrating data feeds