Post reply

DTS disconnected edit: The system cannot find the file specified

  • May 2, 2005 at 4:23 am

    #60560

    I'm trying to sort out a failing DTS package I inherited. It executes (when called by another package) but an ActiveX task reports an error. The error message says that the failure is in task DTSStep_DTSActiveScriptTask_2, but when I try to use the disconnected edit tool to find out the description of this task, I get:

    The system cannot find the file specified.

    I then see some of the basic properties of the package but can't drill to the properties of connections, tasks, etc, as usual.

    Luckily I can find out which task fails by running the package directly (ie not as a call from another package) - but why is disconnected edit failing?

     

    Bill.

  • May 2, 2005 at 5:31 pm

    #556422

    Disconnected edit will check the connections in the package before the dialog opens. You probably have a connection that references a file that can't be found. Maybe a UDL file or something?

    Why do you need to use disconnected edit? The "Properties" and "Workflow Properties" dialogs for the ActiveXScript task should give you all you need.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply