Problem with running a DTS Package from an ASP.NET page

Discussion in 'ASP .Net' started by Leo, Sep 1, 2005.

  1. Leo

    Leo Guest

    Hello all,

    I am having a problem which I cannot seem to find a solution for. In SQL
    Server 2000 I have created a DTS package which imports a Text file into a
    table. When I run the DTS package from the SQL sever itself it executes
    without any isses. However it is failing without any error codes when I try
    to run it from ASP.NET. There seems to be no solution to this so far that I
    have found. I would greatly appreaciate it if anyone has any ideas as to why
    this might be happening or if there's a way to fix it



    Regards,

    Leo
     
    Leo, Sep 1, 2005
    #1
    1. Advertising

  2. Leo

    Clamps Guest

    I just got my DTS package importing .csv's through asp.net. Have you set up
    an error log in the package? Asp.net won't give you good debugging info, but
    that error log will display any sql errors you might encounter.



    "Leo" <> wrote in message
    news:...
    > Hello all,
    >
    > I am having a problem which I cannot seem to find a solution for. In SQL
    > Server 2000 I have created a DTS package which imports a Text file into a
    > table. When I run the DTS package from the SQL sever itself it executes
    > without any isses. However it is failing without any error codes when I

    try
    > to run it from ASP.NET. There seems to be no solution to this so far that

    I
    > have found. I would greatly appreaciate it if anyone has any ideas as to

    why
    > this might be happening or if there's a way to fix it
    >
    >
    >
    > Regards,
    >
    > Leo
    >
    >
     
    Clamps, Sep 1, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peter Afonin

    Cannot execute DTS package from ASP.Net

    Peter Afonin, Aug 29, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    620
    Peter Afonin
    Aug 29, 2003
  2. Yi
    Replies:
    3
    Views:
    5,515
  3. kevin bailey
    Replies:
    5
    Views:
    2,787
    Dino Chiesa [Microsoft]
    Nov 19, 2004
  4. dwight0
    Replies:
    4
    Views:
    629
    Scott Allen
    Jan 27, 2005
  5. Ray5531
    Replies:
    2
    Views:
    3,342
Loading...

Share This Page