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 - 2001-09-13 : 10:08:04
|
| Rojo writes "We have a need to update SQL 7.0 tables every hour from flat files. Our DB Admin stated that DTS was the best way to go but that we had to download that data into temporary import tables and then use a separate application to update the records or delete the unused records. He said that this was needed b/c of the DTS Locking on a table level and would disallow other accesses to the DB. Is this true that I must write a separate application to load data from a temp table into our production tables? Thanks for all your help, great site as well I might add." |
|
|
|
|
|
DTS Table Locks