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-25 : 08:40:46
|
| Mamata writes "Hi SQLTeam, I have a question on DTS.I have written a DTS (data driven query) that either inserts new records or updates existing records from one table in one database to a table in another database. This DTS is Scheduled to run everyday at 3 a.m. When i come in the morning to office and check i see out of 70,000 records only 13000 records have been updated (i have a field that i submit date to it as when it was updated, actually all the records have to be updated and any new rec's have to be inserted).Why is the DTS doing like this, when i run manually it updates all of them, but when schedules as job to run at specific time why is it acting weird, why isn't it updating all of the records, is it getting aborted after some time or is there any reason why it does like this. Please can you help me, this is very important to me and i am unable to figure out this.Please reply to this question by email to m_muttagi@yahoo.comThank you very much.Mamata" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-25 : 18:15:59
|
| Are there any errors in the Package Log?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DTS runs incompletely