Oops I mispoke myself in a previous message. My problem is with an Execute SQL Query task not a Dynamic task.
I have a simple Execute SQL Query that sets a global variable based on the query:
Select esrValue
From ElvisSemaphoreRaw
Where esrSection = 'File2'
And esrKey = 'FileLocation'
The problem is that the task executes but never sets the global variable, and also if I try to preview the result on the task's dialog box I get the error:
"The configuration registry key is invalid."
All attempts to use the Dyn Prop task with a query gives me the same error. Everything else in my DTS (SQL2000, SP2) installation works great.