Hi All,

I setup a DTS package scheduled to run every 5:00PM.
I don't have problem executing the package but the scheduled task always
failed. I believe this is something about permission... what d' you think im
missing???

thanks,
joel

Try turning on logging in the package and the giveaway for a permissions
error is
80040005. Have a look at this article also

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

--

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



"Joel Gacosta" <joel (AT) bluemediacomm (DOT) com> wrote

Hi,
I checked the Job history and found out Error -2147220482 (800403FE) Error
Description: Permission Denied.
this is an active script that access a network resources. i tried the UNC
and mapped drive letter but still the same. i can access the map drive and
UNC at explorer with no problem but not in Scheduled package.
thanks,
joel


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Thanks Allan but still i'm having problem. My SQL Server Agent service
account is the builtin administrator and i'm currently logged as
administrator via Terminal Service connection. i can access the remote
server via explorer using UNC or mapped drive. the DTS package still works
in enterprise manager but failed during job schedule. still the error is
800403FE.

thank you so much for the help. i'm still looking for possible solution.

joel

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Change the account to a Domain Logon. Make sure that logon has permissions
to the text file itself and the encompassing directory/share. Nobody has it
open do they ?


--


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