Re: Scripting.Dictionary causes error when running package outside of designer

#1

Although I have not heard of this problem directly the usual problem of
manual v scheduled is fixed here

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Bill M" <muellerbill.news.invalid (AT) web2news (DOT) net> wrote

Quote:

Hi,

I've developed a SQL Server 2000 package which stores folder names in a
Scripting.Dictionary object which is stored as a DTSGlobalVariable.
when I run the package in the designer it runs successfully. When I
attempt to run the package as a scheduled job or using dtsrunui.exe, it
fails on the first step that attempts to use any properties or methods
of the Scripting.Dictionary object. The package is able to create a
reference to Scripting.FileSystemObject and read the folders in a
directory without generating an error.

The package is owned by my domain login account which is a member of the
sysadmin role in SQL Server and is in the local Administrators group on
the machine. I'm developing using a Terminal Services session on the
database server itself.

Any tips or suggestions are appreciated.

Thanks,
Bill
--
Direct access to this group with http://web2news.com
http://web2news.com/?microsoft.public.sqlserver.dts
To contact in private, remove nn1osp3pa-8mm

#2

Allan,

Thanks for the reply. After I changed the owner of the
job to be the same as the owner of the package (i.e., my
domain login) the problem disappeared so everything below
is just fyi...

I can duplicate it on a different pc (in a different
domain altogether) where the package and the job are owned
by the same domain user account which is a non-admin
account. Looks like using a Scripting.Dictionary object
from a DTS Package may require domain admin rights when
run as a scheduled job or using dtsrunui.exe

Thanks again,
Bill Mueller
MCSD

Quote:

-----Original Message-----
Although I have not heard of this problem directly the
usual problem of
manual v scheduled is fixed here

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Bill M" <muellerbill.news.invalid (AT) web2news (DOT) net> wrote in
message
news:49220N301 (AT) web2news (DOT) com...
Hi,

I've developed a SQL Server 2000 package which stores
folder names in a
Scripting.Dictionary object which is stored as a
DTSGlobalVariable.
when I run the package in the designer it runs
successfully. When I
attempt to run the package as a scheduled job or using
dtsrunui.exe, it
fails on the first step that attempts to use any
properties or methods
of the Scripting.Dictionary object. The package is
able to create a
reference to Scripting.FileSystemObject and read the
folders in a
directory without generating an error.

The package is owned by my domain login account which
is a member of the
sysadmin role in SQL Server and is in the local
Administrators group on
the machine. I'm developing using a Terminal Services
session on the
database server itself.

Any tips or suggestions are appreciated.

Thanks,
Bill
--
Direct access to this group with http://web2news.com
http://web2news.com/?microsoft.public.sqlserver.dts
To contact in private, remove nn1osp3pa-8mm

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Scripting.Dictionary causes error when running package outside of designer

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

Re: Scripting.Dictionary causes error when running package outside of designer - 07-09-2003 , 12:46 AM

Re: Scripting.Dictionary causes error when running package outside of designer - 07-25-2003 , 03:21 PM