ActiveX tasks won't run in DTS - HELP!

From: ajwall23 (andrew.wall_at_abnamro.com)
Date: 05/21/04

  • Next message: ajwall23: "ActiveX tasks won't run in DTS - HELP!" 
    Date: 21 May 2004 07:13:16 -0700

    This has now happened 3 times in the last 2 weeks.

    >
    >
    >This happened again today after I rebooted the server
    > last night. There is an error in the SQL Agent log
    >that says
    >
    >"[LOG] Unable to read local eventlog (reason: The data area passed to
    >a system call is too small) "
    >
    >I don't think this is the cause though because it has happened on
    >other
    >days when this issue has not arisen. Also, I saw some references
    >in newsgroups to Dr. Watson, which I didn't find on the server.
    >
    >Does anyone have an idea what could be causing this?
    >Does the ActiveX tasks depend on a service or DLL that could
    >be restarted or reregistered?
    >
    >I also don't see high CPU usage or memory usage and I don't see
    >any processes that have been running since the task started.
    >
    >Any help would be greatly appreciatted.
    >
    >Thanks,
    >Drew
    >
    >andrew.wall@abnamro.com (ajwall23) wrote in message >news:<a14c3d4.0405181054.2b7a2920@posting.google.com>...
    >> I've got a problem.
    >>
    >> It appears that SQL Server has lost the ability to run an ActiveX Script
    >> within DTS. In my production environment all DTS packages hang
    >> on the ActiveX task in the scripts. I tried to create a new
    >> package with only the Main = DTSTransformStat_OK statement and
    >> that hangs as well. I've created a package with a connection and
    >> an sql statement and that runs fine, but I can't get the ActiveX
    >> script to execute. Since this is a prod environment, I can't reboot
    >> the box.
    >>
    >> Anyone have any ideas that could fix this?
    >>
    >> Thanks,
    >> Drew
    >

  • Next message: ajwall23: "ActiveX tasks won't run in DTS - HELP!"

    Relevant Pages

    • Re: A reboot user
      ... >>I have a colocated server and when I have to get them to reboot it they ... >>on login? ... >>I am guessing I need to create a login script or something similar but I ...
      (Fedora)
    • Re: ActiveX tasks hangs in DTS.
      ... which I didn't find on the server. ... Does the ActiveX tasks depend on a service or DLL that could ... > It appears that SQL Server has lost the ability to run an ActiveX Script ... Since this is a prod environment, I can't reboot ...
      (microsoft.public.sqlserver.dts)
    • Re: WMI Server Reboot Script doesnt work on Win 2003 Server
      ... The issue arises when a user connects to the server with Terminals ... I managed to work around the problem by using 'tsshutdn.exe' to reboot ... >server, then logs off, then the script doesn't work. ... >> When using Win32ShutDown, you need to take the shutdown privilege, ...
      (microsoft.public.windows.server.scripting)
    • ActiveX tasks wont run in DTS - HELP!
      ... which I didn't find on the server. ... >Does the ActiveX tasks depend on a service or DLL that could ... >> It appears that SQL Server has lost the ability to run an ActiveX Script ... Since this is a prod environment, I can't reboot ...
      (microsoft.public.sqlserver)
    • WMI Server Reboot Script doesnt work on Win 2003 Server
      ... I am using WMI in a .vbs server reboot script, and I cannot get the script to ... WMI services are installed and running on the server. ...
      (microsoft.public.windows.server.scripting)
    Loading