?
Solved

Sql server 2k5 wont run scheduled job.  getting error

Posted on 2008-02-12
3
Medium Priority
?
996 Views
Last Modified: 2008-02-21
hello Experts,  
 I keep getting this error everythime the job tries to run.  it wont wont run manually or scheduled.  
Date            02/12/2008 2:27:29 PM
Log            Job History (server)

Step ID            1
Server            domainserver
Job Name            domain account
Step Name            STEP1
Duration            00:00:08
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
Executed as user: domain\account. ...ion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:27:29 PM  Warning: 2008-02-12 14:27:37.58     Code: 0xC0048000     Source: Get Flat File Get Flat File (DTS.Pipeline)     Description: The registry key "SOFTWARE\Classes\CLSID\{904570B-D5ytC-435E-880E-E719bc54672g}\DTSInfo" cannot be opened.  End Warning  Warning: 2008-02-12 14:27:37.58     Code: 0x8004801E     Source: Get Flat File Get Flat File (DTS.Pipeline)     Description: Cannot find the "CurrentVersion" value for component {904570B-D5ytC-435E-880E-E719bc54672g}. The CurrentVersion value for the component cannot be located. This error occurs if the component has not set its registry information to contain a CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is not registered properly.  End Warning  Error: 2008...  The package execution fa...  The step failed.

has anyone ever seen this ...
0
Comment
Question by:gabrielaz
  • 2
3 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 20879431
Do you have Integration Services installed?
0
 
LVL 2

Author Comment

by:gabrielaz
ID: 20884935
yes it is installed.
0
 
LVL 2

Accepted Solution

by:
gabrielaz earned 0 total points
ID: 20885197
figured it out.. the proxy account did not have access to stored procedure so i gave it access now it runs.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question