Schedule DTS ActiveX Script call to COM

  • Hi all,

    I think this is a basic question but I just do not know how to do this.

    I created a VB COM object to handle some serious looping and aggregating of data. I then created an ActiveX Script as part of a DTS package which calls the COM object. Since I compiled the COM object on my machine, when *I* run the DTS package, it works fine.

    In order to run it from a scheduled job, the DBA registered the dll by dragging it over regsvr32 on the server. However, it won't run when the job tries to execute. My previous experience with COM has always been with a transaction server (with an admin person).

    Can anyone help me understand what I need to do to get this working? I would surely appreciate the help.

    Beth

  • Here you can find the solution

    DTS schedule problem

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

    Johnny...

  • Johnny,

    Thanks for the link, unfortunately it doesn't help me as I've already placed and registered the component on the server.

    Beth

  • Check the answer under microsoft news group!!

Viewing 4 posts - 1 through 3 (of 3 total)

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