December 27, 2005 at 12:28 pm
HI,
I have a DTS PAckage which has 'Execute Process Task' Step, to run a .bat file to import files from ftp site. This package is being called by the Job. The job runs fine when the owner is SQL Service acount. When i change the owner to user account, it fails to run under proxy account. Basically Proxy account is missing some permissions. Could anyone help. Here is the error msg.
Executed as user: CORP\NBPROXY. ...Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147024891 (80070005) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4900 DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnSt. The step failed.
Thankyou, Deb.
December 27, 2005 at 2:18 pm
Please don't crosspost.
See reply here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=246794
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply