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