SQL Server Performance Forum – Threads Archive

DTSRun error

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: domainsvc_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.

CHeck whether that account necessary privileges on Operating system to perform the DTS copy operations, if any. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I was able to resolve the problem by adding the account as a local admin. like you said Satya. Thanks

]]>