on 12-02-2009 10:58 PM
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
Hi,
try to configure your SIA Account with a Domainaccount who has write access to the fileshare.
Try again than.
REgards
-Seb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.