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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Logs in DTS execution : Bug?

Author  Topic 

hgorijal
Constraint Violating Yak Guru

277 Posts

Posted - 2005-04-11 : 04:51:41
Here's a scenario...
I've created tasks in DTS, say, 2, 3 and 4. I've saved the dts to log the execution in "Package Properties" (Error File).
Later, I add tasks, say, 1 and 2; so that the task run in the order of 1-2-3-4-5.

But when I execute the package and look at the log file, I see the entries are in order of 2-3-4-1-5. In the order in which the tasks were created; not in the order they are executed.

Wierd!! Huh!!

Any ideas how to fix this...

Also, I want custom messages in the log file..say, to debug.. Any ideas..

TIA..

Hemanth Gorijala
Exchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each.
   

- Advertisement -