Rea Peleg wrote:

> Hi every body
> I'm thinking of using sql server profiler and/or the windows performance
> logs (with sql server objects counters), to trace a problematic job which
> fails to retrieve any rows by executing a dts (wich inbcludes transfare
> data tasks).
> The dts works just fine by it self.
> When scheduled, it does not fail the job or generate any massage,just no
> rows are retrieved..
>
> Can you recomend the best practice with these tools for such a tracing task?
> I'm not sure which of the sqlserver objects counters i should use if at
> all..
> Can sql server profiler have some insite here??
> Thanks again
> Rea
>