sql server dts: I have a scheduled job which run two dts packages in succession. Both
packages are set up to log to sql server and do so if I run the package
from enterprise manager. If I run the packages from the job, the job logs
show that the package steps completed successfully, however there are no
step logs for the packages. Anyone know how to force the package to start
logging or why it's not currently?

We are using SQL2000 and VB6.

Dave Phelan

Whilst i have not seen your problem make sure that your

SQL Server Agent service Account: if the job owner is a sysadmin, has rights
to the SQL Server for logging
Proxy Accout: if job is not owned by a sysadmin, has rights to log to the
SQL Server for logging.

If everything still appears OK then log in as either the Agent service
account or the proxy account and no try executing the package.

Have a read as well of this

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

--
--

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


[quoted text, click to view]