cancel
Showing results for 
Search instead for 
Did you mean: 

Error Opening datafile: Access is denied - Please Help

Former Member
0 Kudos

Hello All,

I have created a batch file with the following code:

DTSRun /S "ServerName" /N "PackageName" /E

I added this batch file as a program object in central management console and scheduled it to run but I am getting an error as follows:

*****************************************************************************************************************************************
DTSRun:  Loading...

DTSRun:  Executing...

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart:  DTSStep_DTSDataPumpTask_1

DTSRun OnError:  DTSStep_DTSDataPumpTask_1, 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:  DTSStep_DTSDataPumpTask_1

DTSRun:  Package execution complete.

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

Purpose of the package is to create a text file on network location.

FYI The above batch file is running fine from command prompt and the package is generating a text file on network location.

Any suggestion to fix this issue will be greatly appreciated.

Thank You

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi,

try to configure your SIA Account with a Domainaccount who has write access to the fileshare.

Try again than.

REgards

-Seb.