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 - 2004-05-13 : 08:10:27
|
| John writes "I have a concept of what I want to accomplish but am unsure if this is a reasonable approach. Please give me advice about thepossibilites or alternatives.I want a program on sql server 2000 on computer #1 to use dts toupdate a table on my hosted sql server on the web (computer #2).Computer #2 sends email to comuter #3 (has same program as computer #1). Computer #3 starts dts package on #3 automatically after the email notification is received and updates tables on #3 from tabes on computer #2. I need computer #3 to react quickly to data change on #1. Thanks for ideas.John" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-13 : 08:27:59
|
| You'd be better off having computer #3 read that table for updates (throw a bit field on there for items that haven't been ran yet. You can run it as often as you wish if you check the bit field as you run them so response time isn't an issue.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
automate dts package with email notification