Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madhu_pulluru
Starting Member
5 Posts |
 Posted - 2008-05-27 : 11:01:42
|
| Hi,I have a SQL Server Agent job set up to run a job that calls a dts package on the server.When I run the DTS Package manually, everything works fine and does what it is supposed to do. When I run the job, The job fails. If somebody had this error can you please help me outI am getting following error in my job...DTSRun: Loading...Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.could you please let me know what is the possible cause for the above error.Many Thanks,Madhu |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-27 : 12:48:53
|
| It says it can't find the file specified. Does SQL agent account has access to file for job? |
 |
|
|
|
|
|
SQL Server Agent job