DTS issue on SQL 2k -- sql server dts

clrevill NO[at]SPAM hotmail.com
8/7/2007 10:23:33 AM

I am getting the following error when I try to run the DTS package
that was is to be run as a scheduled job:

DTSStep_DTSActiveScriptTask_2 DTSRun OnError:
DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0 Error Source= Microsoft VBScript
runtime error Error Description: Permission denied Error on
Line 12 Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help context:
4500 Error Detail Records: Error: -2147220482 (800403FE);
Provider Error: 0 (0) Error string: Error Code: 0 Error
Source= Microsoft VBScript runtime error Error Description:
Permission denied Error on Line 12 Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 4500 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

I can run this as a DTS and it runs perfectly, but when I schedule the
job and then run it, it fails. I have verified that I have
persmission to the shared folder where the template is file is
stored. Any ideas?

Russell Fields
8/7/2007 6:11:35 PM

clrevill,

When the DTS package runs as a scheduled job, it is not running as you.
Either the SQL Server service account or the SQL Agent Proxy account is
used, depending on whether your job is owned by a sysadmin or a less
powerful user.

Whichever account is being used must also have rights to the shared folder.

RLF
[quoted text, click to view]

sql server dts : DTS issue on SQL 2k