By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <no**@none.com> wrote in message
news:OF**************@TK2MSFTNGP14.phx.gbl...
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

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.