April 2, 2007 at 5:51 am
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.
April 2, 2007 at 7:29 am
Are you using SQL Server 2000? I never saw 'dispatch' type before.
http://www.microsoft.com/mspress/books/sampchap/4945f.aspx
This web site showed all the global variables data type and there was no 'dispatch' type.
April 2, 2007 at 7:52 am
I don't think there's a dispatch type either. You can add an ActiveX task and a msgbox(globalvar) in the package and get the result interactively.
April 2, 2007 at 12:53 pm
The Dispatch type is valid. It's used for storing recordsets. To see the values stored in this variable, create an Active x Script task and loop through the recordset.
Dim objRS
Dim i
Dim strValue
Set objRS = DTSGlobalVariables("NameOfYourGlobalVariable").Value
With objRS
Do Until .EOF
For i = 0 To .Fields.Count - 1
strValue = strValue & vbCrLf & .Fields(i).Value
Next
Msgbox strValue
strValue = ""
.MoveNext
Loop
.Close
End With
Set objRS = Nothing
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply