DTS Package 'failing' with GetRegValue Error
Posted on 2006-06-19
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).