User Defined Error in DTS VBA module

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bhu
    New Member
    • Oct 2007
    • 7

    User Defined Error in DTS VBA module

    User Defined Error in DTS VBA module
    --------------------------------------------------------------------------------

    i saved DTS package to VB script file and made it as a module and included in my adp.

    When i compile i get a User defined error, i have referenced to required DTS dll.

    Please let me know what is the error and how to solve it
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    How do you expect us to solve the problem that is at your side.
    Please pass more details about the problem.

    Comment

    • bhu
      New Member
      • Oct 2007
      • 7

      #3
      i got a compile error at the beginning of the code:
      Public goPackageOld As New DTS.Package
      Public goPackage As DTS.Package2
      User defined type not defined.

      If i do the reference to dtspkg.dll it works with no error, but the problem i need to copy the adp and ade to the server and i had the dll copied to a folder along with the adp and ade.

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        Have you registered the DLL in the server ?

        Comment

        • bhu
          New Member
          • Oct 2007
          • 7

          #5
          Can you tell me how to register dll and what are the dll's need to be registerd

          Comment

          Working...