Good afternoon to all!
I am starting to work with DW and SQL 2000 together with Analysis
Server and am needing to know if it is possible and as to make to track
a flow of dts to be able to identify, when to give problem, in which
stage occurred the problem.

Thanks!

There are error logs available on the common tasks and error logs for the
whole package. If I understand your problem correctly, most people find
problems in data flows by running parts in isolation (you can right click
and execute just one task). I have used the technique programmers use of
adding tasks which simply generate information and place it in a file or
email.

It may not help, but the replacement for DTS in SQL Server 2005 has better
debugging and allows you to put viewers at various points to track progress.


Brian Reincke
Parity Training
Lonbdon


"Rainier" <rflandrade@gmail.com> wrote in message
news:1151080918.943193.9460@m73g2000cwd.googlegrou ps.com...
> Good afternoon to all!
> I am starting to work with DW and SQL 2000 together with Analysis
> Server and am needing to know if it is possible and as to make to track
> a flow of dts to be able to identify, when to give problem, in which
> stage occurred the problem.
>
> Thanks!
>