October 17, 2002 at 7:32 pm
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
October 18, 2002 at 3:41 am
In the dts designer go to properties/loging, you can check "fail package on first error" you also could create a error log file. In that file you can see what went wrong.
October 18, 2002 at 5:15 pm
Thanks, I will try that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply