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.

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 DTS Packages-Error

Author  Topic 

madhu_pulluru
Starting Member

5 Posts

Posted - 2008-09-11 : 07:03:40
Hi All,

I have couple of DTS packages in SqlServer 7.0. From last 5 years onwards these DTS pakages are running fine through the automated jobs.

From lastweek onwards the jobs are throwing the below error while running the DTS Packages:-

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


whenever we run the DTS Package manually its running fine. whenever we run through the JOB it is failing.

I would be greatful if you could please let me know your valuable suggestions on the above error.

Many Thanks,
Madhu

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-13 : 23:27:54

See this:

http://support.microsoft.com/kb/274716
Go to Top of Page
   

- Advertisement -