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 |
|
aga17
Starting Member
2 Posts |
 Posted - 2009-10-24 : 18:42:42
|
| I will be receiving updated data every 30 seconds in the form of a txt file. I need to load this data into my SQL database every 30 seconds and need it to be automated (real - time). What would be the best way to do this? I'm fairly new to SQL server 2005 so any help would be greatly appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-25 : 12:45:17
|
| Check out BULK INSERT in BOL. Also SSIS (SQL Server Integration Services) |
 |
|
|
aga17
Starting Member
2 Posts |
Posted - 2009-10-25 : 18:01:27
|
| I will be receiving new data in the form of a new text file every 30 seconds. This data will be sent to the server via wireless transmitter. What would be the best method to do this. This data will eventually be sent a website after it has been imported into the database. From what I have gathered from the methods suggested, I can only used the Update command for a single file. I will be receiving data from 4 transmitters at 60 second intervals, so how should i would i go about doing this? |
|
|
|
|
|
|
Real Time Data Capturing