Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: Problem in executing DTS from ASP page

    Hi,

    I have to execute the DTS package from ASP file.
    But the following line throws error
    Set oPkg = Server.CreateObject("DTS.Package")

    Error type:
    Server object, ASP 0177 (0x800401F3)
    Invalid ProgID.

    Can anybody provide me the solution?

    Thanks,
    Mamatha

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    This call should come from the client that already has SQLDMO installed and properly registered. It looks like this is not the case.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    This is dangerous and I highly reccomend you do not go about this the way you are doing it. An account needs a high level of permission to run a DTS package and from a security point of view you do not want to expose this level of permissions to a login in a ASP file. I usually write an active x com object and bury the login necessary to run a DTS package in the compiled code. If this is a permissions issue, this should resolve it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •