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

[Leo]

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]

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.