DTSRun Error

Last Post 11 May 2006 12:51 AM by SwePeso. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
matey
New Member
New Member

--
11 May 2006 12:06 AM
I'm having trouble with executing a DTS package both as a job or by executing the package via DTS, I get the following error below. Can someone please tell me what I'm doing wrong. I changed the owner of the package from me to the account that runs SQL Server (2 node Clustered server)

Executed as user: domain\svc_sqlserver. ...art: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 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 42 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 42 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -214722044... Process Exit Code 1. The step failed.
SwePeso
New Member
New Member

--
11 May 2006 12:51 AM
See MSDN KB for this Microsoft solution.
nosepicker
New Member
New Member

--
11 May 2006 06:38 AM
I don't know if making a registry change is all that necessary yet. The key looks like "Permission denied Error on Line 42". Are you executing a script or stored procedure? Find out what's happening on that line and see if you resolve the permission problem.
SwePeso
New Member
New Member

--
11 May 2006 09:25 AM
Yes, you're right.

I was assuming he already had checked the most obvious places, since it can be read from the error description.


Acceptable Use Policy
---