Running a DTS job fails

Last Post 12 Apr 2006 10:21 AM by amossql. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
amossql
New Member
New Member

--
12 Apr 2006 06:11 AM
DTS package will excute correctly but when i schedule a job it fails with the following error:

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: Path not found Error on Line 14
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 1100
Error Detail Records:
Error: -2147220482 (800403FE);
Provider Error: 0 (0)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found Error on Line 14
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.

The owner of the package has sysadmin right in SQL also is a member of Administrator group
amossql
New Member
New Member

--
12 Apr 2006 10:21 AM
Sql Agent has admin right to the data server.
amossql
New Member
New Member

--
12 Apr 2006 10:21 AM
Sql Agent has admin right to the data server.
amossql
New Member
New Member

--
12 Apr 2006 01:08 PM
I restart sql agent with administrator account not local account. Now DTS job completes.

Thanks
You are not authorized to post a reply.

Acceptable Use Policy