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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-03-01 : 15:01:58
|
| Hi…allI will just explain whole scenario what I m facing in tricky problem..We have xml files coming at regular interval by some other source into sql server 2000…daily having records near @10000 to 70000…we have job scheduled to run it regular interval…we doing this by some filter criteria… suppose the flow is like staging table into secondary table and then final into primary table….We design DTS package accordingly means take the records from staging table put into secondary table and then into primary table…(near @ 8 task involved in it…)Suppose xml file came at 8:30 am and our DTS package will run at 9:00 am…and then 11:00 am and the 1:00 pm like that….what I observing from many days is that after running job at 9:00 am successfully some good data still pending in secondary table not processed into primary table. But when again job ran at 11:00 am it processed that pending good records into primary table…some times when I ran this job manually through DTS design level the good data that pending in secondary table processed!!!My question is that why this job not processed all the good records in single shot????T.I.APapillon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-01 : 15:11:48
|
| You've got some problem in your DTS package. Without seeing the code, it's hard for us to help.Tara Kizeraka tduggan |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-03-03 : 11:14:00
|
| hi tara..i checked my DTS package but nothing i found in it as wrong...see when i ,manually ran this DTS (from design) that time my all good records are processed but when i ran this by agent then that time some good records are left behind to process.....if there is problem with my DTS then when i ran manually that time also records are supposed to be pending then why that time records moved?????T.I.APapillon |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-03 : 11:50:17
|
| There could be quite a few reasons for this behaviour, but all of them will be due to the DTS or the way that you identify the "good records". Post an example of your code and data and i'm sure we'll be able to help.. |
|
|
|
|
|
|
regarding records processing???