Hi, I wondered if anyone else has experienced this. We have a DTS that is run every day to update several tables in SQL server 2000 from data stored in a visual foxpro database. The package completes, reporting success, but upon inspection of the tables not all have been populated. Sometimes it works,sometimes it doesn't! If it fails the tables can be populated by opening the DTS in design mode and running the failed transformations individually. I wondered if maybe it was some sort of locking issue, but this is happening even if I kick all users out. And why is it reporting that it worked fine when it did not? Anyone got any thoughts.
TIA