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 (which 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

Profiler will not do you much good neither will the other things. The job
is probably still failing (well the package anyway) and not bubbling up the
error message.

Have a look here

http://support.microsoft.com/?kbid=269074

I would log onto the box as the SQL Server Agent service account and try to
execute manually


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote