Like many others i have a dts procedure that runs fine manually but on a
schedule fails. I have all permissions set as admin and the servers are
communicating. When this problem actually started is when I updated the
MDAC to 2.7. It was running fine prior to this. I am using sql 7. No
error messages are logged, it just stalls on step one. Thank you for
your time.
M

--
Posted via http://dbforums.com

What happens when you login as the SQL Server Agent Account and execute the
package ?

Maybe you are seeing this

http://support.microsoft.com/default...b;en-us;290077

--

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



"aquaman" <member33489 (AT) dbforums (DOT) com> wrote

Runs great, that is why this is confusing me. I am not getting any
errors either. Just stalls on step 1.
Thank you
aquaman

--
Posted via http://dbforums.com

Microsoft Knowledge Base Article - 269074 may help.
Harv.