Re: ActiveX tasks won't run in DTS - HELP!

bb_43_at_hotmail.com
Date: 05/22/04

  • Next message: kjpierick_psa: "SQL Server network backups" 
    Date: Sat, 22 May 2004 01:23:00 GMT

    >>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?

    Can you run a .VBS file from the command prompt using Cscript.exe?

  • Next message: kjpierick_psa: "SQL Server network backups"
    Loading