Re: DTS ActiveX Scripting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 12:54:51 -0000

What is the error message?

Usually this problem is resolved after reading this article

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

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Risun" <risun@wmdata.com> wrote in message
news:127d101c41196$69bb5db0$a501280a@phx.gbl...
> When running a DTS package interactively the package
> executes ok.
>
> When scheduled, the package fails when accessing a
> Scripting.Dictionary object that has been instansiated
>
> The user running SQL Server Agent has sysadmin priviliges.
> In DCOMCNFG the user is granted Allow Access in
> Default Security->Default Access Permissions.
>
> SQL Server 2000 with SP3 on win 2000.
>
> What is the problem ?
>
>

Relevant Pages

  • Re: DTS Package Execution Error Log: Error -2147220440
    ... can't grab a decent error message to work with. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... the package still works in the background - most of the ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package run from Access on a different server: Error -2147467259; access denied
    ... only does the error message appear but the performance is much, ... Is there a way of triggering a DTS package in SQL Server (so that the ...
    (microsoft.public.sqlserver.dts)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: Schedule DTS Package
    ... And how do you try to connect to SQL Server in the package? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > an error message and described below. ...
    (microsoft.public.sqlserver.dts)