dbTalk Databases Forums  

Problem reading DTS global variables in COM+

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem reading DTS global variables in COM+ in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
john.tennyson@mckesson.com
 
Posts: n/a

Default 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!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.