SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error while executing DTS package in SQL server agent


Error while executing DTS package in SQL server agent

Author
Message
vidya.k.krishnan
vidya.k.krishnan
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1
Hi


i have a DTS package which runs successfully if done manually . I tried scheduling in SQL server 2000 Agent .I belong to the Sysadmin Role. When i run the job , it fails with the following error

Executed as user: NC006DEVD08D\SYSTEM. ...t: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied Error on Line 70 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 70 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help contex... Process Exit Code 1. The step failed.


i am new to SQL server agent . i think the job is running using an incorrect account .i want to execute the Job using the NT Windows account . How can we do that ??
michal.lisinski
michal.lisinski
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1904 Visits: 1105
Hi
There are a few common problems you might encounter when you run DTS packages as scheduled jobs in SQL Agent:

Relative Path - A relative path (or drive letter) is specific to the current location of the package, unless the referenced files are also moved to the server, the package execution fails.

COM Components in ActiveX Scripts - Microsoft ActiveX Data Objects are called in an ActiveX script, the called components must exist on the computer from which the DTS package is being run. If the package is scheduled to be run by SQL Agent, the called components must be loaded on the SQL Server.

Mapped Drives -If the package relies on the physical location of a file designated by a mapped drive letter, the package may fail when it is run as a scheduled SQL Agent job. SQL Agent is a Windows NT service and Windows NT services cannot see mapped drive letters, use UNC path.

Br.
Mike
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search