We are still running on SQL 7 here. I built several dts packages that I
start with a dtsrun command in a sql job. These have run just fine for
several months with no failures. We now upgraded the server and went from
MDAC 2.7 to MDAC 2.8. This change is described in Security Bulletin
MS03-033. Now the jobs fail starting them with the job but run fine by
executing the package itself. They display several symptoms in the list of
databases Can you help me here?

Maybe it is rather like this old problem

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


remember DTS is client side so if the MDAC versions are different between
the box that created the package and the Server (when scheduled) then this
may be the problem.



--

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



"Rick" <bob (AT) bob (DOT) net> wrote