I would have to say I am having the same problem. I created a class in VBScript and use the Scripting.Dictionary as an array to store a record. But the scheduled DTS package stops as soon as it goes to create the object. I thought it was a bad memory chip or a memory leak, because the program has been running for 6 months, but failed 3 times this past week. It failed maybe once a month prior to this last week, always on the same line.

I am debating on whither to rewrite my code to use temporary tables instead of doing it in memory

----- Risun wrote: ----

H

We are trying to run a DTSpackage through a scheduled
job. It fails

The package is running 2 ActiveX scripts that uses
Scripting.Dictionary objects.

The first ActiveX script fills a dictionary object and
assigns a global variable 's value a reference to the
object
Set DTSGlobalVariables("dictionary").Value =
theDictionaryObjec

The second script retrieves the Dictionary object by
assigning a local variable
Dim localDictionar
Set localDictionary = DTSGlobalVariable
("dictionary").Value
This works and a validation such as If localDictionary Is
Nothing returns Fals

Next, we want to access localDictionary
Dim someItem
someItems = localDictionary.Items

and the package fails when assigning someItems

If trying to loop through localDictionary instead

Dim di
For Each dic In localDictionary.Item
Nex

the package fails on For Each dic In localDictionary.Item

Everywhere i search for help it says it has to do with
permissions but no-one tells me what permissions are
missing?!
The user that runs the SQL Server Agent has administrator
rights on the server and also sysadmin in SQL Server
The same user is the owner of the job

The server is a Win2000 and SQL server 2000 with SP3

Has anyone here had any similar problems
What did you do to correct it
/Risu