Have a look at this article.
In 99.5% of the cases it is the answer
http://support.microsoft.com/?kbid=269074
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"Dave" <Dave (AT) discussions (DOT) microsoft.com> wrote
Quote:
initiated manually. This is driving us nuts. Whenever I manually open and
run the job from the console it works fine. However, whenever I schedule the
job, it fails on two steps of the job. The two steps that its failing on are
db pushouts to a server that is on the same subnet. The steps that succeed
are the ones that are db pushouts to remote servers that are connected via
WAN on a differant subnet. Any ideas? Connectivity doesnt seem to be the
problem. Permissions? Thanks in advance. |