Problem reading DTS global variables in COM+ -
02-18-2005
, 10:43 AM
I am working on some code that during a customer Visual Basic script
step in DTS initializes a call to a COM+ object (written in VB6) as so:
Dim oComp
Set oComp = CreateObject("CustomPackage.Component")
Main = oComp.Initialize(DTSGlobalVariables.Parent)
Within the Initialize function (which we have verified is beign gotten
to by logging entries in the event viewer) we are attempting to
retrieve global variables by using a standard
object.GlobalVariables("Id")
This appears to be working on a large number of systems, but on two
isolated systems (one WindowsXP, SQL2000SP3a the other Windows2000SP4,
SQL2000SP3a) I am getting a "Permission Denied" when attempting to
retrieve the GlobalVariables
Does anyone have any idea what would cause a "Permission Denied" when
attempting to retrieve a GlobalVariable?
Note: the COM+ component is running as a specified NT account, the SQL
Agent is running under the System Account, and if I change the COM+
component to run as logged in user to debug it in VB, it works...
Regrettably I have been unable to track down what permissions it would
be talking about.
Thanks in advance for any help! |