SQL Job access denied

• Henry Vandersteen-357352

  SSC Journeyman

  Points: 81

  More actions

  August 10, 2006 at 9:21 am

  #103216

  Hi, heres my problem. DTS runs fine, schedule job does not. Heres the log file.

  The execution of the following DTS Package succeeded:

  Package Name: MPC_SUPPLIER_TEST

  Package Description: DTS package description

  Package ID: {010CFD9A-77FD-427C-9131-C25E1D582398}

  Package Version: {CB855FC9-EF7C-4223-B1DE-F9B821CF3EB0}

  Package Execution Lineage: {97B5EB9E-8122-492E-8DB9-F051F212C5C7}

  Executed On: PIPESQL1

  Executed By: SYSTEM

  Execution Started: 8/3/2006 4:57:00 PM

  Execution Completed: 8/3/2006 4:57:01 PM

  Total Execution Time: 0.328 seconds

  Package Steps execution information:

  Step 'Copy Data from Results to \\LSF1\MBSSHARE\MPC_FILES\MPC_SUPPLIER.TXT Step' failed

  Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider

  Step Error Description:Error opening datafile: Access is denied.

  Step Error code: 80004005

  Step Error Help FileTSFFile.hlp

  Step Error Help Context ID:0

  Step Execution Started: 8/3/2006 4:57:00 PM

  Step Execution Completed: 8/3/2006 4:57:01 PM

  Total Step Execution Time: 0.328 seconds

  Progress count in Step: 0

  ****************************************************************************************************

  I am using a network account with administrator permissions.

  Any suggestions? Thanks(UserID=360472)

  More, from job history.

  Executed as user: PIPESQL1\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  Copy Data from Results to F:\MBSShare\MPC_FILES\SendFiles\MPC_ACCOUNT.TXT Step   DTSRun OnError:  Copy Data from Results to F:\MBSShare\MPC_FILES\SendFiles\MPC_ACCOUNT.TXT Step, Error = -2147467259 (80004005)      Error string:  Error opening datafile: Access is denied.         Error source:  Microsoft Data Transformation Services Flat File Rowset Provider      Help file:  DTSFFile.hlp      Help context:  0      Error Detail Records:      Error:  5 (5); Provider Error:  5 (5)      Error string:  Error opening datafile: Access is denied.         Error source:  Microsoft Data Transformation Services Flat File Rowset Provider      Help file:  DTSFFile.hlp      Help context:  0      DTSRun OnFinish:  Copy Data from Results to F:\MBSShare\MPC_FILES\SendFiles\MPC_ACCOUNT.TXT Step   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.

  I dont know above it mentions F drive, since I am using a UNC path for the file destination. This may be the issue

  Thanks for your help

  Henry

• Jo Pattyn

  SSC-Dedicated

  Points: 32520

  More actions

  August 10, 2006 at 2:27 pm

  #654429

  Does sql agent have sufficient permissions to access the file(s)? Does it have the same network administrator permissions?