VBScript Run error running scheduled DTS package

[NeeNee]

I am trying to schedule a job which runs a DTS package which builds a text file using VBScript. I can run the package manually from the Enterprise Manager but it won't run when it is scheduled.

This is the error:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220485 (800403FB) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied
Error on Line 16 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100
Error Detail Records: Error: -2147220485 (800403FB); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied
Error on Line 16 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100

DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

It indicates that it is a permission error on line 16. Line 16 in the script sets variable to the Scripting.FileSystemObject in order to create the file and be able to write to it.
Does anyone know why I can run the package manually but not scheduled and how do I give permission to SQLServer to access the scripting library(if that is what is causing the error)

Thanks
Denis

 

[Wholsea]

I am having this exact problemw hen I try to run DTS Packages. Have you had any success?

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[jelf]

Wholsea

Search for "Package Scheduling and Security Issues" in BOL. This gives a very good guide to permissions for DTS packages.

 

[pkailas]

Make sure the the SQL Agent is logging on with a Domain User if you are going across computers in a domain or at least a valid user account if not. I believe the default is the local system account..