Click to See Complete Forum and Search --> : SQL Server 2000 Global Variable


Bill Crawley
April 2nd, 2007, 07:35 AM
Hi All,

I've been given a DTS written some time ago to find out why it's going wrong.

Within the Globalvariables there is a Variable declared as type Dispatch and the value says <not displayable>

How can I interogate this to see the value? Can I get in to an 'edit' situation in some way so that I can see the value.?

Also what is the significance of the 'Dispatch' type? i.e. I understand string, int etc but not this type.

exterminator
April 4th, 2007, 04:32 AM
I am not sure there is a type named Dispatch. Could be a UDT - have you searched for that? Otherwise, I don't have a clue.