Hi There,

I have a little problem here. I created an ActiveX package that uses a filescriptingobject to copy some files from one server to another. I can execute the package without errors, but when I try to schedule the package it fails to run.

The owner of the package has rights on the destination server.
The username displayed in the error message is the logon name for SQL Server Agent and is different from the package owner, but that user also has rights to the destination server.

We've tried various owner names, but get the same error each time. We're a bit worried about changing the logon to SQL Server Agent because of how it might affect other packages. Would that fix our problem?

Below is the error message.

Thanks for your help.

Paul O

Executed as user: server\username.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
Error string:
Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied
Error on Line 29
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 29
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.
Process Exit Code 1. The step failed.