Need to run a MS SQL DTS Pkg from ASP...Help

Discussion in 'Databases' started by waldedg, Feb 9, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. waldedg

    waldedg

    I am trying to run a MS SQL DTS Pkg from Classic asp. Any help on the coding? I get the following err. msg:

    Server.CreateObject Failed on line 13

    Line13: Set oPkg = Server.CreateObject("DTS.Package")

    Thanks in advance.

    Doug
     
    waldedg, Feb 9, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You cannot do that on the web server. The server do not have this object installed.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Feb 9, 2005
    #2
  3. waldedg

    waldedg

    Is there a way to run a MS SQL server Stored Procedure from ASP that will run a DTS package?

    Thanks for the help.

    Doug
     
    waldedg, Mar 8, 2005
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    sure. you can build that page and schedule it with the scheduled task manager in the control panel.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 8, 2005
    #4
  5. waldedg

    waldedg

    What I am trying to do is to update a table in the SQL DB from a table in a local MS Access database from different customers. So I don't really want to have to schedule a job every time. Any suggestions.

    Thanks,

    Doug
     
    waldedg, Mar 8, 2005
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page