Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 735
  • Last Modified:

DTS Package 'failing' with GetRegValue Error

Hi,

I have a few DTS packages (which I didn't create, they were already in place when I started working in my current job) and they have been on and off failing.

I have been logging the DTS packages execution and am trying to pinpoint the problem.

The following error is getting returned (but not for all DTS packages that run):

GetRegValue(): Unable to RegOpenKeyEx () No Error Message Available for error# 0, 1815

This line is directly after "DTSRun:  Package execution complete."

At first I thought it was a permissions issue, so I have made the account that the SQL Agent runs under a local administrator of the DB server to see if it makes a difference. It did the first time, but I have just run another DTS package (still with the Agent user as a local admin) and I got the error again.

Has anyone experienced this before?

I've done some searching but haven't found anything very useful (mind you I just might not have looked hard enough).

Cheers
Oz
0
OzSQL
Asked:
OzSQL
  • 2
1 Solution
 
Anthony PerkinsCommented:
Without knowing what exactly the DTS Packages actually do, it is difficult to guess.  For example, if they access resources outside the SQL Server server and they are run as scheduled jobs, than setting the SQL Server Agent service startup account to the "local administrator" simply does not cut it.

Can you duplicate the error if you execute the DTS Package interactively?
0
 
OzSQLAuthor Commented:
I'll give you the points LOL

It's not actually the problem I thought it was. This is not causing a failure.

Cheers
Oz
0
 
Anthony PerkinsCommented:
>>I'll give you the points LOL<<
There is no need.  Consider posting the actualy solution for future users or post a message in Community Support to have the question deleted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now